Opening a word doc from Access 2007 vba but having it remove the save features.

[PuddinPie]

Hello all,

I have an intresting one. I have a form where a user click's on a document title and it opens the document in word using

Application.FollowHyperlink strLink, , True

I'm tring to figure out a way of opening the document so that the save options are disabled.

Any ideas?

Thank you.

 

[Mr. B]

Using the Follow Hyperlink method to open the Word documents will not allow you to have any control over enabling or disabling the save options when opening the documents. However, if these are existing documents, it would be possible to use VBA code in the On Open of the documents and replace the default menus with new custom menus that do not provide the save options.

Here is a link that might help:
http://social.msdn.microsoft.com/forums/en-US/vsto/thread/088da6c4-cbef-4920-abbb-1c0424da9285

 

[PuddinPie]

It does not have to be opened by using a hyperlink, that's just the way I have it for now.
The article was good but its talking about changin the VBA and XML of the document. I wanted to change it in the VBA call from access to the document.

Any other ideas?

 

[Mr. B]

If you use MS Word automation (This means actully creating an instance of MS Word and opening a document) then you could continue to work with the document using VBA code from Access. That is what I had in mind.

 

[PuddinPie]

Do you have an example of this that you could point me too?

 

[Mr. B]

I do not have any examples that I can direct you to. However, you should be able to use Google or other search engine and get information about automation for MS Word from Access.