Consulting

Results 1 to 4 of 4

Thread: Solved: Need a line of code I can open a folder with

  1. #1
    VBAX Regular
    Joined
    Sep 2006
    Location
    Midwest
    Posts
    35
    Location

    Solved: Need a line of code I can open a folder with

    What I'm doing is creating a simple program to assist in the creation, and mailing of reports. Creation of the reports..no problem. Send the reports to a folder...no problem. Create an email that will send out 7 spreadsheets with no editing or assistance..no problem. What I'd like to do is have a command that will open the folder and allow the user to check out spreads before sending. I was hoping to link Windows Explorer to a button so the user never has to exit the application from start to finish. Anybody know of a "Call Shell" routine or some other way to accomplish this goal?
    Tom
    Some say that the glass is half empty
    Some say that the glass is half full
    I say they delivered the wrong size
    glasses

  2. #2
    VBAX Expert
    Joined
    Jul 2004
    Location
    Wilmington, DE
    Posts
    600
    Location
    [vba]
    Application.FollowHyperlink "\\put\UNC\path\to\folder\here"
    [/vba]
    Regards,

    Patrick

    I wept for myself because I had no PivotTable.

    Then I met a man who had no AutoFilter.

    Microsoft MVP for Excel, 2007 & 2008

  3. #3
    VBAX Regular
    Joined
    Sep 2006
    Location
    Midwest
    Posts
    35
    Location
    Patrick,
    Works perfect! I owe you a cup of coffee!
    Tom
    Tom
    Some say that the glass is half empty
    Some say that the glass is half full
    I say they delivered the wrong size
    glasses

  4. #4
    VBAX Expert
    Joined
    Jul 2004
    Location
    Wilmington, DE
    Posts
    600
    Location
    Quote Originally Posted by Tom
    Patrick,
    Works perfect! I owe you a cup of coffee!
    Tom
    I wish coffee were easily transferable by email

    Glad to help.
    Regards,

    Patrick

    I wept for myself because I had no PivotTable.

    Then I met a man who had no AutoFilter.

    Microsoft MVP for Excel, 2007 & 2008

Posting Permissions

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