ruairi costello
asked on
opening word(2013) document on sharepoint 2013
Hi - Im hoping someone can help me as the internet so far has not come up with anything. We recently upgraded to sharepoint 2013 which I believe is causing the issue.
The steps are:
open a word document on sharepoint with bookmarks in it
copy data from excel to the word document
save as different name
The issue is in the new version of sharepoint when I open it, it is in some sort of protected mode - can not enter data - one has to select edit document to enter data.
I wish to do be able to edit document in VBA
Here is my code.
Set doc = wd.Documents.Open("http://******************.docx", ReadOnly:=True)
Is there something to add to the end of the line to open document in read mode but so can be edited
Ive tried removing readonly := true piece etc but nothing works so far
Thanks
Ruairi
The steps are:
open a word document on sharepoint with bookmarks in it
copy data from excel to the word document
save as different name
The issue is in the new version of sharepoint when I open it, it is in some sort of protected mode - can not enter data - one has to select edit document to enter data.
I wish to do be able to edit document in VBA
Here is my code.
Set doc = wd.Documents.Open("http://******************.docx", ReadOnly:=True)
Is there something to add to the end of the line to open document in read mode but so can be edited
Ive tried removing readonly := true piece etc but nothing works so far
Thanks
Ruairi
Is it something to do with having to "Check Out" the document?
ASKER
Thanks rob
I'm unsure as don't get an option to check out.
There is a manual fix by going to file/options/general/start up options
Untick :open email attachments and other uneditable files in reading mode '
I need to do this is vba as there are many users
Regards
Ruairi
I'm unsure as don't get an option to check out.
There is a manual fix by going to file/options/general/start
Untick :open email attachments and other uneditable files in reading mode '
I need to do this is vba as there are many users
Regards
Ruairi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.