
Results tagged “Visual Basic for Applications” from Ask Westley!Have a Word Macro Detect Your Thumb Drive
Category is Microsoft Office
Microsoft Windows
I keep all my word files on a 8 gb USB jumb drive so that I can take them from one computer to another. I have all my templates and custom macros in one directory. I have a macro to attach the template to the documents. The problem is the drive letter changes as I move the USB drive from computer to computer. Then I get an error and I have to use debug to change the drive letter at the start of each session. Is there any way to make the macro look for the template taking into consideration that the drive letter may change. Thank you, © 2005-2009 by Westley Annis. All Rights Reserved.
|