Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,071
Default 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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Files Won"t Open Automatically Canon Excel Discussion (Misc queries) 2 October 2nd 09 08:06 PM
How can I set up Excel 97 to automatically convert/open .csv files Jean-Luc240660 Setting up and Configuration of Excel 1 July 27th 09 03:50 PM
sort non delimeted non fixed width alpha numeric column jwbuyer Excel Discussion (Misc queries) 2 December 3rd 08 05:40 PM
Excel 2002 : Can it open up link files automatically ? Mr. Low Excel Discussion (Misc queries) 1 August 31st 07 10:18 AM
How do I get excel files to open automatically from directories? Damian Excel Discussion (Misc queries) 2 January 3rd 06 02:51 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"