Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 04-23-2014, 03:43 PM
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 worked years in a development and production environment, so I understand that users get a final version. The development version is, well, the development version.
Quote:
If, in Document_Open the VBA takes control of the User's options and does not allow the User the option of entering the VB Editor, then there is no easy way for the Developer to access the VBE by simply opening the document. (In the processes I am developing the document is created solely from User input to the various Userforms.)
1. in Document_Open VBA does NOT, repeat NOT, take control of the User's options. VBA does only what you (as the developer) tells it to do, in the code in Document_Open. No more, No less. If you do not write code into the Sub Document_Open, then nothing happens. It only does what you tell it to do.

2. "and does not allow the User the option of entering the VB Editor".
a) well sort of, in that while the code is executing, no, there is no access to the VBE, but only a the fact you can not start it.
b) why why why on earth do you want users to access the VBE anyway!!!!???
Quote:
then there is no easy way for the Developer to access the VBE by simply opening the document
There is a very easy way, once Document_Open finishes, open the VBE. This has nothing to do with whether the Open instruction came from double click or RMC-Open.

Yes of course users have a "closed" version - and therefore why are they going into the VBE. Yes of course developers have an "open" version for further development. In which case, as long as nothing is actually executing, they have full access to the VBE.
Reply With Quote
 

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 12:38 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