Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Open a .txt file from Excel (Excel sp)

    From a macro in Excel i want to open a readme.txt file so the user can see comments in it. I know how to call notepad.exe but not how to open a file so the user can view it. Thank you for the help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Open a .txt file from Excel (Excel sp)

    If you use
    ActiveWorkbook.FollowHyperlink "CocsReadme.txt"
    (substitute the correct path), the text file will open in whatever application the user has associated with .txt files.

Posting Permissions

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