Forum Discussion
Solved
VBA command Workbooks.open no longer works
I have an Excel spreadsheet which contains macros, three of which access files on the digitallook website. I run the macros every weekend. They have worked well for years but, last weekend, Excel s...
The thing is that if you use data import from web, you don't need the VBA to load the data anymore. you would simply refresh the data you load....
I don't know Excel for Mac but maybe you can find the option like this (see video)
Has it ever worked in 2020?
The URL contains the year, maybe it has something to do with that?
http://www.digitallook.com/cgi-bin/dlmedia/price_download.cgi/download.csv?start_day=13&start_month=01&start_year=2019&end_day=13&end_month=01&end_year=2020&type=html&action=download&csi=50032
Do you always want to download the last 365 days?
The URL contains the year, maybe it has something to do with that?
http://www.digitallook.com/cgi-bin/dlmedia/price_download.cgi/download.csv?start_day=13&start_month=01&start_year=2019&end_day=13&end_month=01&end_year=2020&type=html&action=download&csi=50032
Do you always want to download the last 365 days?