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!!!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,951
Messages
5,834,531
Members
430,295
Latest member
amdis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top