ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to open comma delimeted files automatically (https://www.excelbanter.com/excel-programming/336328-re-how-open-comma-delimeted-files-automatically.html)

Tushar Mehta

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