ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pass an argument to Excel workbook (https://www.excelbanter.com/excel-programming/295761-pass-argument-excel-workbook.html)

dorothy lo

Pass an argument to Excel workbook
 
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?

Frank abel

Pass an argument to Excel workbook
 
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

-----Original Message-----
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?
.


dorothy

Pass an argument to Excel workbook
 
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.

-----Original Message-----
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

-----Original Message-----
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?
.

.



All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com