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)
Seems to work just fine for me. Have you tried Data, Get Data, From Workbook, From Text/CSV?