ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is this possible? (https://www.excelbanter.com/excel-programming/344336-possible.html)

SkylineGTR

Is this possible?
 
Hi,

I would like to be able to do the following:

<a href="c:\test.xls?param1=123&param2=1234" /

so that when clicked "test.xls" opens and extracts param1 and param2
and does some processing with them ... is this possible. If not what
would be the appropriate route to take?

Thanks in advance for any help!


Tushar Mehta

Is this possible?
 
Being able to pass arguments to a workbook would be nice but XL doesn't
support the capability of treating workbooks as functions/subroutines.

One way out that I can think of is to write your own VB/VBA/VBScript
code that would run XL, open test.xls, replace param1 and param2 with
the desired values, and do a recalculation of the workbook. Of course,
you would also have to define what to do with the recalculated
workbook.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article .com,
says...
Hi,

I would like to be able to do the following:

<a href="c:\test.xls?param1=123&param2=1234" /

so that when clicked "test.xls" opens and extracts param1 and param2
and does some processing with them ... is this possible. If not what
would be the appropriate route to take?

Thanks in advance for any help!



SkylineGTR

Is this possible?
 
Thank you for taking the time to answer Tushar.

Back to the drawing board then.



All times are GMT +1. The time now is 02:00 PM.

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