Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Here's one for the masters
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Here's one for the masters
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. Sharon wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Masters Golf Pool | Excel Discussion (Misc queries) | |||
Convert Number to Text, Masters? | Excel Discussion (Misc queries) | |||
Learning from the masters | Excel Programming | |||
Kung Foo Masters Only | Excel Programming | |||
VBA Masters | Excel Programming |