Passing argument to excel
Hi all...
Interesting task here...
I am using a Visual Basic app (NOT excel) to send a Shell() command that
launches an excel sheet:
"C:\MySheets\Go.xls"
Windows finds Excel, loads the Go.xls sheet, and all is well...
Here is the issue: I wish to pass an argument ALONG with this shell command
that can be "seen" by Go.xls
For example, I'd like to have this work:
Result = Shell("C:\Mysheets\Go.xls " & iArgument)
(where iArgument is an integer variable)
A macro in Go.xls would need the iArgument to know what to do...
Is there a way to accomplish this?
Thanks so much!
M
|