Computer geek, and self-appointed know-it-all, Westley Annis answers all those hard 
questions about anything related to computers and technology, as well as business and 
political questions.

Results tagged “Visual Basic for Applications” from Ask Westley!

Have a Word Macro Detect Your Thumb Drive

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,
Larenzo

Question asked on February 4, 2009 8:55 AM :: :: Comments (0) :: TrackBacks (0)
© 2005-2009 by Westley Annis. All Rights Reserved.

Valid XHTML 1.0!