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