PDA

View Full Version : Open Excel file via Web Page with Arguments



kkw
11-27-2008, 07:08 PM
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

jfournier
12-01-2008, 09:19 AM
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