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. |
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 |
All times are GMT +1. The time now is 12:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com