VBA cannot merge the work of multiple users -- how to allow this?

[Windows 10]

I am a single user, but work on my Excel workbooks on both a Mac and a Windows 10 computer. I use the Winodws 10 one to perform updates on Excel workbooks created on the Mac, using VBA. I transfer to files through One Drive, which I have on both machines, and then run the VBA on the Windows machine. I do so because VBA is so inadequate in the Mac version of Excel. The worksheets taht I need to [process are .XLSM files.I have Office 365 personal, always updated to the latest release.Although I am one person, Windows sees the workbook coming from the Mac as a file of a differen

Continue reading...