Solved

opening word(2013) document on sharepoint 2013

Posted on 2016-09-15
4
24 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 33

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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 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