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!

Register Yourself Login