Export into Excel without saving first?

[Lifeseeker]

Hello,

I have a report that has an Excel and PDF icons and when they are clicked, gives users a prompt to save either in Excel or PDF format.

My question is.....would be it possible to override the saving part? Can you export it into Excel first then save? Users just wanna view the file in Excel without having to save the report first.

Is it possible? Can it be done using a macro of some sort?

Thanks for comments/thoughts

 

[boblarson]

Check out my code here:
http://www.btabdevelopment.com/ts/default.aspx?PageId=10
I have several variations which might work for you and all you need to do is paste that code into a standard module and then name the module something other than the name of the function and then you can call it. I don't think I have any of them directly save the file so the user must. I am planning on creating a single use function for all of it but just haven't gotten around to it yet.