Forum Discussion
VBA command Workbooks.open no longer works
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)
Dear JKPieterse ,
Thanks for the link. Unfortunately, I can't get it to work for me for the same old reason - the icons on the ribbon are missing from my Excel version (for Mac). Also, this article appears to cover imports from an existing file, rather than a web page. If you find anything on how to import from a website's database into Excel 365 for Mac, then I'd be grateful if you'd let me know.
Thanks for your help so far.
David89A If you open the attached, are you able to refresh the data?
Dear JKPieterse
Thanks for your info. I suppose we'll just have to wait until Microsoft gets around to repairing its software.
- 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.
I clicked the "Refresh All" icon in my Data ribbon and received the message in the attached. I don't understand it. Can you decipher it?
Dear JKPieterse ,
I opened the attachment you sent. It opened as an Excel spreadsheet with the six column headings but no data. It also came with a "Security Warning" which said, "External Data Connections have been disabled" and a button labelled "Enable Content". I clicked the button but nothing changed on the spreadsheet.
Does this help to diagnose the original problem?
