Excel VBA Developed on PC Will Not Run on Mac

[AMRICE01]

I am an Excel VBA developer amd am quite proficient on the PC. However, an app I have developed needs to be ported to a Mac (which I have done nothing on the Mac). I would be estatic if someone can provide guidance in how to get my PC Excel VBA automation to run same on the Mac. There are several posting on this site about spot solutions, but I have not found any posts which gives me a simplistic and complete solution.

My Mac user says something about using Parallel on the Mac, but when he installs it,it reference using some special Excel version on the Mac. I am so dumb about the Mac.

I have posted a screenshot of what the Mac user encounters when trying the run the Excel VBA app on Hia Mac

Is there a blog, or book, or site where I can go? Any help or guidance would be greatly appreciated.

Thanks
AMRICE01

 

[MARK858]

MAC's don't support ActiveX controls, either use Form controls or set up a virtual machine version of Windows (I haven't set one up in years but it is covered online search Virtual Machine (bootcamp) or Parallels for MAC depending what version of MAC you have. You would have to do this on every MAC running the App)

 

[RoryA]

What is your code doing with CreateObject?

 

[AMRICE01]

What is your code doing with CreateObject?

Thanks Rory... You nailed it!! With my initial VBA coding, I had intended to retrieve certain metadata, which required FSO object. In final design, the metadata was not required. When I commented out the FSO statement, the VBA code works as required on the Mac.

Thanks again, and this is a great forum
Al