Announcement

Collapse
No announcement yet.

Open Text File With Notepad

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Open Text File With Notepad

    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!

  • #2
    Re: Open Text File With Notepad

    Code:
        intResult = Shell("Notepad.exe " & strFileName, vbNormalFocus)
    Greg
    Excel 2003-SP2 on Win XP.

    Comment


    • #3
      Re: Open Text File With Notepad

      Thanks that works :]

      Comment

      Working...
      X