VB:intResult = Shell("Notepad.exe " & strFileName, vbNormalFocus)
Hello,
I have created a macro that auto generates SQL code based on user input from a worksheet. The SQL script is written to a text file. I would just like to visually open the text file with notepad when the macro is finished executing. Anyone know how to do this?
Thank you!
VB:intResult = Shell("Notepad.exe " & strFileName, vbNormalFocus)
Greg
Excel 2003-SP2 on Win XP.
Thanks that works :]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks