
Results tagged “VBA” 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, Displaying the Following Year in a Word Document
Category is Microsoft Office
Hi, I have a word document that is a membership renewal form that is sent out once a year... I want to place a date (Year only) field on the form that displays the year that the form refers to ... eg the form is sent out towards end of 2008 for the 2009 calender year so I want to display 2009 then 2010 at end of 2009....etc As I am currently doing this I want to automate the form so as anyone who sends them out in future does not have to remember to update for each year (as has been missed in past) I have had a look at date field options but can not find a way of doing it. Any help gratefully accepted..... Cheers, © 2005-2009 by Westley Annis. All Rights Reserved.
|