Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is this possible?
Hi,
I would like to be able to do the following: <a href="c:\test.xls?param1=123¶m2=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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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¶m2=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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is this possible?
Thank you for taking the time to answer Tushar.
Back to the drawing board then. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|