open file with application

[lekmall]

Does anyone know how to open a text file with a specified application? The extension of the file that I want to open is not .txt and it won't be registered on the user's computer. I just want to call 'Notepad.exe' and then specify the file it is to open????

Thanks!

 

[lekmall]

here's the solution!

I found this solution at:
http://vbnet.mvps.org/index.html?code/shell/shellexecute.htm

works great if anybody needs it.

Thank you!

 

[Monkey Man]

Does anyone know how to open a text file with a specified application? The extension of the file that I want to open is not .txt and it won't be registered on the user's computer. I just want to call 'Notepad.exe' and then specify the file it is to open????

Thanks!

Can't you just rename the file to have the txt extension:

strPth = "C:\Whatever.jps"
strNewPth = Left(strPth,len(strPth)-3) & "txt"

Name strPth As strNewPth

then open it with:

application.FollowHyperlink strNewPth

then when done reverse the naming process

Name strNewPth As strPth

HTH

Jordan

 

[lekmall]

Thanks, Monkey Man.
I thought of that, but can't do it. When the file has been opened with Notepad, it will have the .txt extension. The user may want to save the file while it's open and they will be confused when they see that the extension is not what it should be and I would get calls telling me "Hey, what's going on? We're not used to this!"