universal macro

[ChuckW]

Hi,

I have a cvs file that gets downloaded from Access once a
week. The file name and path are always the same. I
want to run a macro against this file but since the file
is over written every week I am unsure how to do this. Is
there a global macro that can be created and then saved
and then used even if the file gets over written? I want
to keep this as a cvs file as well.

Thanks,

Chuck

 

[JulieD]

Hi Chuck

if you store the macro in your personal macro workbook (personal.xls) it
will be available to all workbooks and will not get over-written.

Cheers
JulieD