Results 1 to 1 of 1
2003-01-28, 16:24 #1
- Join Date
- Feb 2001
- Yilgarn region of Toronto, Ontario
- Thanked 0 Times in 0 Posts
Developer's Best Friend (Word97/SR2)
This template contains two macros I find invaluable in my development work.
VBE and VBEUp both open a template and switch to the VBE with a maximised window.
VBEUp increases the version number of the file being opened.
To see how it works, create a dummy template (for purposes of this test) with an 8-character file name, of which the first five are alphabetic and the next 3 are digits, thus: Utils182.dot. Save and Close the file Utils182.DOT.
Now use the macro VBEUp to open the Utils182.DOT. You will be presented with a copy of Utils182.DOT saved as Utils183.DOT.
Numbers are free.
During a long day of development, I like to save audit-trail copies of my work before/after major changes, or before/after meal breaks etc.
The most time-saving feature of these macros remains Kevin's :
<pre> Application.ShowVisualBasicEditor = True ' Open VBE
Application.VBE.MainWindow.WindowState = 2 ' same as vbext_ws_Maxz
Woody's Lounge http://www.wopr.com/cgi-bin/w3t/showflat.p...ew=&sb=&o=&vc=1
If your template filename is void of digits, VBEUp will produce an incrementing extent.
And yes, you are not restricted to using this technique for DOT files. Works well on DOCs, too.