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)
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 PascalKTeam ,
I see. My Excel for Mac ribbon offers far fewer options than yours in the videos you sent. However, I'm sure there must be a way to do it. I'll have a bit of web-browse and see if I can find it.
I noticed I'd missed a question you asked earlier; namely about whether it has ever worked in 2020. Yes, it worked fine last week on the 4th of January and accurately downloaded data covering the year end. Something has changed since then: I know it's not my macro but I can't find out what it is.
Your suggestion about the automatic update looks like a better solution to the problem, however, so I'll pursue that. Thank you again.
- You might try this then, I expect that is available to MAC Excel: https://jkp-ads.com/articles/importtext.asp
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?
