Hi All,

I'm openning an xls-file that contains a VBA macro in IE.
Is there a way how to pass parameters from IE to the macro?

In Excel2000 I just passed it in the URL:
http://localhost/file.xls?param=value
and then read it from Application.Caption property.

Unfortunately, in Excel2002 and 2003 this approach
causes problems with PivotTables: they are attempting to
reference "file.xls?param=value" file and fail,
as the file name is just "file.xls".

Any ideas?