Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default from VBA open text file in default text editor application

Thanks bunches, Tom.

That does indeed do the trick.

Now that I've got that working instead of having to use Notepad, I've
found that I need to put a Wait call right after it to keep from
executing too quickly a statement that deletes the text file that is
being opened (a Kill statement). The text file being opened is a
temporary file for the user to view. Two seconds seems to be enough
time for the application to launch and load the file. Perhaps this is
necessary because of differences between VBA's Shell command and the
API's ShellExecute.

Anyway, it works now.

Cheers,

Brian

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
Make hyperlink to open another application that default one Jean-Luc Links and Linking in Excel 0 September 30th 09 07:12 PM
Default settings when opening a text file with Excel David Fitzwater Excel Discussion (Misc queries) 1 August 12th 08 08:07 PM
Importing text file and changing default to delimited [email protected] Excel Discussion (Misc queries) 0 April 30th 08 11:45 PM
Text Import Wizard: Default File Origin Resolution [email protected] Excel Discussion (Misc queries) 0 March 21st 07 05:08 PM
Excel VBA - open text file, replace text, save file? Cybert Excel Programming 2 October 2nd 04 01:05 AM


All times are GMT +1. The time now is 01:43 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"