Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default 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!

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,071
Default 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!


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default Is this possible?

Thank you for taking the time to answer Tushar.

Back to the drawing board then.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"