troubleshooting Question

opening word(2013) document on sharepoint 2013

Avatar of ruairi costello
ruairi costello asked on
Microsoft SharePointMicrosoft Office
3 Comments1 Solution66 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
ruairi costello

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros