Getting data from Google multiple sheets into Excel

andyeaston

New Member
Joined
Sep 20, 2016
Messages
16
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!!!
 

Forum statistics

Threads
1,086,202
Messages
5,388,386
Members
402,115
Latest member
ypompoms

Some videos you may like

This Week's Hot Topics

Top