Open Excel run macro?

[Aveit]

Hi

I have a batch file that basically uses sqlcmd to export data to a text file weekly (each one is named based on date)

Is it possible to run a script that would import this data to excel and then run a macro which would format the data?

Thanks Paul

[MrJinje]

Easy. Record your data import and formatting using the Macro Recorder. Then open up VBA editor and call your macro on workbook open.