If you save a copy of your Excel file under a standard file name, say
"LargeFile.xls" then you could set up a macro to find and run "LargeFile.xls"
to output a saved text file.

You would save this macro under All Open Workbooks, then open Excel without
opening your large file in order to find and run your macro.

HTH

" wrote:

I have a big Excel file and a macro which processes this Excel file and
spits out a text file. Is it possible to run this macro without opening
the Excel file? Opening a 100MB excel file takes time and doing it 100
times over is not fun...