export data from access into multiple spreadsheets

[janet sun]

Hi, I have a prolem with creating only one function to export the three
access tables into three sheets of one excel file. Can we do this by the
function of "transferspreadsheet".

 

[Klatuu]

What version of Access?
If you are at least 2000, you may get away with something the the Help file
says you can't do. The TransferSpreadsheet has an argument for a range. It
states
that if you enter a range for an export, it will fail. I have not done it
myself, but I have seen some posts that say it will work. So you function
will have 3 Transferspreadsheets, each with the same file name, but different
query names and different range names.