Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
help opening file with command button
- Thread starter Clegg25
- Start date
Easy way of opening external programs from VB is the Shell command:
Shell "pathname\xl.exe a:\fred.xls", vbNormalFocus
where pathname is the complete path to your Excel exe, xl.exe is the name of your xl app and the rest is the path and filename to open
Also read faq222-2244 for guidance on how to get better answers from the forum
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
Shell "pathname\xl.exe a:\fred.xls", vbNormalFocus
where pathname is the complete path to your Excel exe, xl.exe is the name of your xl app and the rest is the path and filename to open
Also read faq222-2244 for guidance on how to get better answers from the forum
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
- Status
