output to excel

[moufasa]

Hello,
I have 4 queries that I want to output to an excel file. I want the user to
have the option to choose a file location and file name each time they output.
The transferspreadsheet works well with multiple sheets in the same workbook
but I have to define a file location and name. I tried outputquery to
"book1", true and that works fine for the first query only. I get an error
message for the second query outputting to that same "book1". That way they
have the active excel workbook open and then can "save as" via excel which
would be great if I can send all four queries to that active workbook.


Any suggestions? Thanks!

 

[Guest]

Try using the Open/Save dialog to prompt the user for a filename.
Copy the code from the MVPS page:
http://www.mvps.org/access/api/api0001.htm
and paste it into a new module.
Use the Testit() function to return the filename.

jmonty