Link to home
Start Free TrialLog in
Avatar of ruairi costello
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
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Is it something to do with having to "Check Out" the document?
Avatar of ruairi costello
ruairi costello

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
ASKER CERTIFIED SOLUTION
Avatar of ruairi costello
ruairi costello

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial