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)
Apparently this doesn't work yet. Excel on Mac is supposed to be able to refresh PowerQuery queries (this is one), but apparently fails for some reason.
Dear JKPieterse
Thanks for your info. I suppose we'll just have to wait until Microsoft gets around to repairing its software.