Transferspreadsheet w/multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Is it that it will only have Sheet1, and another day Sheet1 and sheet2,
etc

or

that only sheet1 will have information?
 
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?
 
Back
Top