Open Excel Document With VB
Here's what I'd like to do.
I'd like to put a command button on my VB form that says "View File" or something to that effect. When the user clicks that button all I want it to do is open up a specified file in Excel.
Basically, the button would just function as a shortcut to the Excel file. The file would open in Excel as well. All VB does is open it.
Simple huh?
I know I'll need "App.Path" in there somewhere because that's where I'll store the file, I'm just not sure how to open it.
Re: Open Excel Document With VB
This FAQ thread has the answer:
http://www.vbforums.com/showthread.php?t=348138
You just need to use the path to your file in the appropriate place.