Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Open Text File With Notepad

  1. #1
    Join Date
    20th November 2007
    Posts
    24

    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!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th August 2006
    Posts
    16

    Re: Open Text File With Notepad

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

  3. #3
    Join Date
    20th November 2007
    Posts
    24

    Re: Open Text File With Notepad

    Thanks that works :]

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Deleting Text From An Open Text File
    By eljays in forum EXCEL HELP
    Replies: 6
    Last Post: February 28th, 2007, 07:40
  2. Open Text File From File Manager Vs. Within Workbook
    By james.aldcroft in forum EXCEL HELP
    Replies: 2
    Last Post: October 3rd, 2006, 14:25
  3. Opening and writing to new file in Notepad
    By kevin562 in forum EXCEL HELP
    Replies: 5
    Last Post: July 29th, 2004, 04:19
  4. Open file search and import text file
    By infojmac in forum EXCEL HELP
    Replies: 2
    Last Post: July 6th, 2004, 18:04

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno