RECrerar
08-07-2007, 04:08 AM
Hi I have been using VBA in Excel for a few weeks with no problems. I have recently needed to write a macro in word to automatically convert a .doc file to a .txt file. The macro itself works fine my problem is this:
I have the macro saved in a module of an open document. The document I want to convert is open and the active document. I select Alt F8 to bring the list of available macros and my macro does not appear in the list (I do have the list selected to 'all active templates and documents'). Why does it not appear in the list? and How can I get it to appear?
If I have the code in a module in the 'Normal' file it is visible and can be execute, however I do not want to have it here as eventually it will need to be available across a network and hence be saved in a file that can be opened from any of the network computers.
Finally, I will eventually want this program as an Add-In, is this possible within word?
I have the macro saved in a module of an open document. The document I want to convert is open and the active document. I select Alt F8 to bring the list of available macros and my macro does not appear in the list (I do have the list selected to 'all active templates and documents'). Why does it not appear in the list? and How can I get it to appear?
If I have the code in a module in the 'Normal' file it is visible and can be execute, however I do not want to have it here as eventually it will need to be available across a network and hence be saved in a file that can be opened from any of the network computers.
Finally, I will eventually want this program as an Add-In, is this possible within word?