Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You may be able to accomplish the same effect though not necessarily
with the stated command. Write a VBScript script that (1) gets the desired filename through its arguments, (2) uses automation to run XL, and (3) tells it to open the desired file. To get the syntax for (1) and (2) adapt the code at http://msdn.microsoft.com/library/de...l=/library/en- us/script56/html/wscondrivingapplications.asp To get the code for (3), open XL, turn on the macro recorder (Tools | Macro Record new macro...), do whatever it is you want to do through the GUI, and turn off the recorder. XL should give you the necessary code, which you can adapt to use the result of (1) -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article . com, says... Excel pros please help! I need to make Excel start from command line and open a comma delimeted text file. (like this; excel.exe myCommaDelimetedFile.txt) File names will have different names but the same extention (*.txt) Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Files Won"t Open Automatically | Excel Discussion (Misc queries) | |||
How can I set up Excel 97 to automatically convert/open .csv files | Setting up and Configuration of Excel | |||
sort non delimeted non fixed width alpha numeric column | Excel Discussion (Misc queries) | |||
Excel 2002 : Can it open up link files automatically ? | Excel Discussion (Misc queries) | |||
How do I get excel files to open automatically from directories? | Excel Discussion (Misc queries) |