Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-22-2014, 09:27 AM
fumei fumei is offline VBA to identify how Word was invoked Windows 7 64bit VBA to identify how Word was invoked Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

I believe it is bark bark. Double clicking and RMC and selecting Open fire the same thing. That is, if the file in Explorer is a document. If it is a template then they fire different things.
Quote:
the User, and I can no longer access the VBA easily
Do not know what you mean by this. Please clarify.
Quote:
I just wondered if I could use the alternate method of opening the document (RMC & Open) to allows access to VBA by detecting it in the "Private Sub Document_Open()" code.
That does not make any sense. Once Document_Open fires you have access to everything in VBA.
Reply With Quote
  #2  
Old 04-23-2014, 01:59 AM
Sorcerer13 Sorcerer13 is offline VBA to identify how Word was invoked Windows Vista VBA to identify how Word was invoked Office 2010 32bit
Novice
VBA to identify how Word was invoked
 
Join Date: Sep 2012
Location: God's Own County
Posts: 16
Sorcerer13 is on a distinguished road
Default Further details....

Thanks Fumei....

As I suspected, the same process seems to be fired by DC or RMC+Open.

So I'll rephrase the original question: When in Document_Open, can I look at some system variable to determine what method was used to open the document?

I strongly suspect the answer is "No".

As to the next bit, I currently have VBA in Document_Open which immediately shows an Userform etc. So from then on, processing is restricted to options offered to the User.
To amend/update the code, I normally access the document's VBA by opening the document, then use Alt+F11, but the above restrictions mean that option is no longer available to me.
Therefore, at the moment in Document_Open I detect the current User's name, then, for selected Users (me!), I offer the option of normal processing or VBA access.

I was just musing on the idea of simplifying this process....
Reply With Quote
Reply

Tags
document options, document properties, vba script



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to identify how Word was invoked How do you identify the ID of a picture in PowerPoint? CatMan PowerPoint 4 04-17-2012 03:29 PM
How to identify whether Word 2007 was used to create a document saved as Word 2003 noviceatwork Word 0 03-08-2012 06:40 AM
VBA to identify how Word was invoked identify non-members from two lists rterrain03 Office 5 12-01-2011 01:41 PM
how to identify the word files created using Windows or Mac Operating System? mariaprabudass Word 0 08-06-2010 05:52 AM
C# API to identify the uncommitted changes in Excel and Word document? althafuddeen Excel 0 04-06-2010 07:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft