Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Make hyperlink to open another application that default one | Links and Linking in Excel | |||
Default settings when opening a text file with Excel | Excel Discussion (Misc queries) | |||
Importing text file and changing default to delimited | Excel Discussion (Misc queries) | |||
Text Import Wizard: Default File Origin Resolution | Excel Discussion (Misc queries) | |||
Excel VBA - open text file, replace text, save file? | Excel Programming |