I have a table in HTML created by PHP.
I would like to export this to Excel and then run a macro in Excel to tidy up the code.
Only problem is I can't do this without creating an Excel template on the server and pushing this to the user through a webpage.
So, I would like to pass a querysting to Excel to tell it which stored procedure to run when it opens and run some tidy up code. That way I give the user the template and they just open it and all the data is present.

ANy ideas?