hi,
Macros reside in the specific file that the macro was written in. when you
create a new excel file, it does not contain macros nor can it reference
other macros unless you write a macro to call the other macro.
to do what you want and keep it simple, you would have to have a standard
import file that everyone would use to import the text file. this standard
import file would contain the format macro. then after running the format
macro, save the file off as a different name using filesaveas. the file
saveas part can be added to the format macro. to get the syntax, just do it
on record macro.

Good luck

FSt1

"Pam Coleman" wrote:

If I create a macro on my PC to format a text file that is being brought over
to excel on a weekly basis (and it is saved in a file on our server), can the
macro be saved so that every week when someone else opens up a new file, the
macros can run to format that file? Sometimes I notice when you create a
macro in your workbook on your PC, it does not show in other excel
workbooks. Thanks,