Applying the same macro to multiple excel files
 

Hi,

I have created a macro which allows me to convert some of the
information in my excel file to text file. The problem is that I have
dozens of excel files which I need to apply this macro to in order to
create text files for each of these files. Is there an easy way in
which I can apply the macro to all these files? Maybe there is a quick
way of loading a macro into an excel file so that it runs when you open
the excel file.

Thanks for your help,

Barry.

Applying the same macro to multiple excel files
 

Create an add-in.

http://support.microsoft.com/default.aspx?kbid=211563

How to create an add-in file in Excel 2000


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


wrote in message
ups.com...
Hi,

I have created a macro which allows me to convert some of the
information in my excel file to text file. The problem is that I have
dozens of excel files which I need to apply this macro to in order to
create text files for each of these files. Is there an easy way in
which I can apply the macro to all these files? Maybe there is a quick
way of loading a macro into an excel file so that it runs when you open
the excel file.

Thanks for your help,

Barry.