Hello,

Cant get this line to work

Workbooks.Open Filename:="https://drive.google.com/file/d/0B-Sf9qx1nwCyVmsyWnRUZ3RRTEo1akE4Snpsb0o4Q09fRnIw/"

It's a plain old xls excel workbook - it simply opens a new blank workbook (without even any grid lines).

I want to be able to open locally the excel workbook in Google drive or download and save it so that I can open it or else failing that download a text file for the same purpuse.

Here's the shared link

https://docs.google.com/file/d/0B-Sf...psb0o4Q09fRnIw

Kind regards.

Simon