Pass an argument to Excel workbook

  • Thread starter Thread starter dorothy lo
  • Start date Start date
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?
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is this expected behavior? 2
How to pass arguments to an Excel macro using Dynamic Data Exchang 2
Can I pass arguments to my formatted empty spreadsheet file? 3
empty arguments recalculation 2
empty arguments 2
passing value to excel 2007 document solution on web server 1
Open Workbook Macro - with a twist 1
Schedule downloads in VBA 5

Back
Top