Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 26
  • Last Modified:

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
0
ruairi costello
Asked:
ruairi costello
  • 2
1 Solution
 
Rob HensonIT & Database AssistantCommented:
Is it something to do with having to "Check Out" the document?
0
 
ruairi costelloAuthor Commented:
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
0
 
ruairi costelloAuthor Commented:
I believe I solved it by putting this like in after.
Doc. Printpreview

This allows data entry
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now