Here's one for the masters

[Guest]

I have a mixture of old and new systems. I need to automatically save a .dif
file as an .xls. Is there a way to automatically say.. run a macro to open
the file in Excel then save it? This of coarse would have to be done without
user intervention. A batch file or scheduled task.

 

[Dave Peterson]

Start a new workbook
start recording a macro when you open the .dif file, parse it and save it.
stop recording
Rename this macro: Auto_Open

Then save this workbook as a nice name

And then open that workbook when you need to do the work.

Remember that if you do try to automate this, you'll want to make sure that
macro security is set to low--so the user doesn't have to say it's ok to run
macros.