Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open .txt, Save as .xls from command line
If your text file is always the same name, then start a new workbook.
Turn on the macro recorder and record your steps when you do it manually. Save that workbook as a nice name. You could open that workbook and run the macro whenever you want to import that text file. Or you could give the macro the name: Auto_open Then put a shortcut to that workbook on your desktop. Just double click on the shortcut, excel will open your file, run the macro and tada! You could even add: Thisworkbook.close savechanges:=false right before the closing "end sub" and the macro workbook will close (without saving any changes--so don't do this while you're testing if you haven't saved it!) graham wrote: I think the subject says it all! I have a txt file that I receive daily that I would like to create a .bat file to open, delimit based on 'space', and save as a xls file. I'm clueless, any help would be greatly appreciated! THANKS! -- Dave Peterson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open .txt, Save as .xls from command line
perfect, Thanks.
One additional question if I may: What if I want to close excel.exe completely, not just the workbook? "Dave Peterson" wrote: If your text file is always the same name, then start a new workbook. Turn on the macro recorder and record your steps when you do it manually. Save that workbook as a nice name. You could open that workbook and run the macro whenever you want to import that text file. Or you could give the macro the name: Auto_open Then put a shortcut to that workbook on your desktop. Just double click on the shortcut, excel will open your file, run the macro and tada! You could even add: Thisworkbook.close savechanges:=false right before the closing "end sub" and the macro workbook will close (without saving any changes--so don't do this while you're testing if you haven't saved it!) graham wrote: I think the subject says it all! I have a txt file that I receive daily that I would like to create a .bat file to open, delimit based on 'space', and save as a xls file. I'm clueless, any help would be greatly appreciated! THANKS! -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open .txt, Save as .xls from command line
Right before the "End Sub"
application.Quit 'then End Sub graham wrote: perfect, Thanks. One additional question if I may: What if I want to close excel.exe completely, not just the workbook? "Dave Peterson" wrote: If your text file is always the same name, then start a new workbook. Turn on the macro recorder and record your steps when you do it manually. Save that workbook as a nice name. You could open that workbook and run the macro whenever you want to import that text file. Or you could give the macro the name: Auto_open Then put a shortcut to that workbook on your desktop. Just double click on the shortcut, excel will open your file, run the macro and tada! You could even add: Thisworkbook.close savechanges:=false right before the closing "end sub" and the macro workbook will close (without saving any changes--so don't do this while you're testing if you haven't saved it!) graham wrote: I think the subject says it all! I have a txt file that I receive daily that I would like to create a .bat file to open, delimit based on 'space', and save as a xls file. I'm clueless, any help would be greatly appreciated! THANKS! -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as Command Line | Excel Discussion (Misc queries) | |||
Open, Save and close Excel 2007 file with a cmd command | Excel Discussion (Misc queries) | |||
Command line to open a specific worksheet | Excel Worksheet Functions | |||
How do i convert excel to csv in command line? ( not save as) | Excel Discussion (Misc queries) | |||
can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) |