Transferspreadsheet w/multiple worksheets

[Guest]

I have an Excel spreadsheet that varies each day as to whether it has 1
worksheet, 2 or even 3.

How would I code the macro action "TransferSpreadsheet" range to allow for
these variations?

Thank you in advance!
JCarter
Still Learning

 

[Ron2006]

Is it that it will only have Sheet1, and another day Sheet1 and sheet2,
etc

or

that only sheet1 will have information?

 

[Guest]

I have this very same issue...only I use dating for my worksheets (i.e
070106, 070106 (2), 070106 (3) etc)...Depending on the day, I can have 3-6
worksheets that I need to transfer to my Access DB. When I run the macro, it
only transfer a single worksheet, and it happens to be the same one that I
used to set up the db?? Is there a better way?