![]() |
How to open comma delimeted files automatically
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! |
All times are GMT +1. The time now is 02:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com