How to access SQL report from Excel file?

[liorlankril]

I have a SQL report (reporting service). I open the report by it's URL link. aftrer I open it I operate Export to Excel file.
I want to write a VB macro to the Excel file witch read values of the SQL report paremetrs and put them on the header of the Excel file (not the header of the report, I dont want to use Header on the report)

How can I do it???????

 

[Sheco]

You want the Excel file created by exporting a report to contain a macro?

 

[liorlankril]

I want to use this macro in SQL report that been export to SQL Report.

 

[xlbo]

You can't have a VBA macro in the excel file created by RS.

Why do you not want to put this information into the report so that it gets exported directly ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question