Solved

opening word(2013) document on sharepoint 2013

Posted on 2016-09-15
4
16 Views
Last Modified: 2016-11-01
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
Comment
Question by:ruairi costello
  • 2
4 Comments
 
LVL 31

Expert Comment

by:Rob Henson
ID: 41799618
Is it something to do with having to "Check Out" the document?
0
 

Author Comment

by:ruairi costello
ID: 41799801
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
 

Accepted Solution

by:
ruairi costello earned 0 total points
ID: 41799868
I believe I solved it by putting this like in after.
Doc. Printpreview

This allows data entry
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now