Macros keep disappearing

Hi: I'm working on a .csv file and have written a macro for it. The macro
works fine but when I go to re-open the file (after saving it first), the
macro is no longer there.

Is this something to do with it being a .csv file or what?? I keep having to
re-enyter it each time I re-open the file, which is annoying.

Thanks for any help!

"OzBushDude" <OzBushDude@discussions.microsoft.com> wrote in message
news:A92E6ACD-7953-4120-A5CB-FDC38E27054A@microsoft.com...
> Hi: I'm working on a .csv file and have written a macro for it. The macro
> works fine but when I go to re-open the file (after saving it first), the
> macro is no longer there.
>
> Is this something to do with it being a .csv file or what?? I keep having
> to
> re-enyter it each time I re-open the file, which is annoying.
>
> Thanks for any help!

A csv file cannot contain macros. Save as an xls file and see what happens.