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

[Tom]

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?:banghead:

[matthewspatrick]

Application.FollowHyperlink "\\put\UNC\path\to\folder\here (file://\\put\UNC\path\to\folder\here)"

[Tom]

Patrick,
Works perfect! I owe you a cup of coffee!
Tom

[matthewspatrick]

Patrick,
Works perfect! I owe you a cup of coffee!
Tom

I wish coffee were easily transferable by email :thumb

Glad to help.