I am trying to launch an application from an Excel spreadsheet using a macro and the VB shell function. I want to be able to pass the text from a cell to the macro as a command-line argument for the application.
The solution from http://www.excelforum.com/showthread.php?t=579609 is close to what I need, but I need it to pass the actual text and have the application launch using the text as an argument.
I appreciate any help.
Last edited by VBA Noob; 03-09-2007 at 08:32 PM.
Shell is fairly limited, the ShellExecute function will allow this. You will need to reference the Windows API library you will find many examples by Googling on ShellExecute.
Hope this helps
Unfortunately, I know nothing about programming so any insight on whats necessary to accomplish the task would be very helpful.
Kind Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks