Posts by mmarofsky


    Thanks, I give that a try.
    I was hoping there was a way to call a macro from the commandline via a startup switch

    I have received the same reply on many forums but....

    The .csv file generated by a separate program is NOT an excel file and can NOT have macros/events.

    I am not converting to excel, I am editing a .csv file then resaving as a .csv

    My question is specifically aimed at externally (DOS Batch file) telling Excel to open a .csv file and then run a macro defined in the personal.xls (Personal workbook)

    I need to edit a .csv file which is generated from another program.
    What I do now is have a DOS batch file which runs the program to generate the file then opens the file in excel.

    I then manually run a macro to format/sort the data.

    How can I automate the step to run the macro?
    Wasn't there at one time a commandline switch to specify a macro?

    Any help would be appreciated.

    - MM