Excel 365 - how to open a .xlsm file stored on an image disk

  • Hi all,

    I'm using Excel 365 for Mac 16.17 on MacOS High Sierra 10.13.6.
    The macro recorder will not record open file command.
    I need VBA code to open a workbook stored on a disk image file located on my desktop.

    Appreciate your help.

  • Thank you Tom but that link is broken.

    I have found the solution, the code is:

    Workbooks.Open FileName:="/Volumes/ ... example .../ .... abc.xlsm ... "

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!