Simple Question

[maximo1970]

Hi all,

I'm trying to run a Macro in Excel 2000 at startup. I ca't see that there is a command line to do this, Microsoft seemed to have removed it from Office 97.

My basic plan is to convert a number of XLS spreadsheets into a CSV text files, but need to remove and change some of the data first.

 

[GlennUK]

You could have the macro activated by a Workbook_Open event and place the file containing the macro in your XLStart folder so that it is opened when Excel starts.

That should do what you want.

Cheers, Glenn.