Pass an argument to Excel workbook

D

dorothy lo

Can I pass an argument to Excel workbook without running
the VBA in Excel?
Now, I want to wake up the Excel workbook by schedule and
pass an argument to it for running its macro?
 
F

Frank abel

Hi
not quite sure what you're trying to achieve and what you
mean with 'without running the VBA'

One way could be to use the OnTime method and put some
code in the workboo_open event. But that's just a guess
 
D

dorothy

After I run a java program, I will get a value. I want to
pass this argument to an Excel macro. How can I pass an
argument to Excel?
Thanks.
 
Top