Getting data from Google multiple sheets into Excel

[andyeaston]

All -

I've checked previous threads on this topic and havent found what I'm looking for.

In my VBA I am downloading data from the first sheet on a Google Sheet workbook. This has not been a problem. I am using this code...

' Download Production Schedule as csv


ActiveWorkbook.FollowHyperlink Address:="https://docs.google.com/spreadsheets/d/1rnNjaCV8pXrwoHQW6pnh8RTHYNNl5dvfT7Z0pE7-0Ps/export?format=csv" & strSKU, NewWindow:=True



' Open and activate Production Schedule

Workbooks.Open "C:\Users\aeaston\Downloads\MOTT LLC ORDER PRODUCTION SCHEDULE - Schedule.csv"
Workbooks("MOTT LLC ORDER PRODUCTION SCHEDULE - Schedule.csv").Activate

The problem comes when I try to do another download to download the 4th sheet called 'wood-glass door' it only wants to download the first sheet again

Any ideas?
Thank you!!!