Forum Discussion

David89A's avatar
David89A
Copper Contributor
Jan 13, 2020
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...
excel
Excel on Mac
Macros and VBA
office 365
  • PascalKTeam's avatar
    PascalKTeam
    Jan 13, 2020

    David89A 

    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)