Dynamic Worksheet Created from hyperlink

Originally Posted by mxp

Hi,

Dony know if this is even possible, but i would like to me able to dynamically generate a worksheet from a passed variable.

i know such things are possible in other languages (such as php), but have no idea if excel is cappable of such things

Probably easier if i try and explain the scenario. I want to create a copy of information stored in an access database (but only if and when it is required). I know in other languages i could create a hyperlink that contained a variable (for example

PHP Code: 

http://www.foobar.com/page.php?id=100 


) where i pass the variable id=100 through the link. i could then generate a page based on this variable.

Is this even possible with excel (using the hyperlink worksheet function perhaps?) or not?

Many thanks for any advice/help

mxp

Hi,

David McRitchie has some information re Worksheet generation at his site http://www.mvps.org/dmcritchie/excel/sheets.htm
Perhaps this will assist you.

---