Hi all,
We would like to open an Excel file under a web page (e.g. <a href="abc.xls"), and together passing some arguments (variables) to that Excel file for VBA processing. How can we do that? Kindly advise.
Many Thanks!
kkw
Hi all,
We would like to open an Excel file under a web page (e.g. <a href="abc.xls"), and together passing some arguments (variables) to that Excel file for VBA processing. How can we do that? Kindly advise.
Many Thanks!
kkw
As far as I know it isn't possible to pass command line arguments to Excel and have them passed to VBA. The only way I can think of is to port your VBA code from Excel into a VB executable that opens Excel and works based on your command line arguments.
-Jon