Excel VBA Developed on PC Will Not Run on Mac

AMRICE01

New Member
Joined
Oct 23, 2019
Messages
3
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
 

Attachments

  • LEGEND_IMAGE.png
    LEGEND_IMAGE.png
    176.3 KB · Views: 47
Last edited by a moderator:

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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)
 
Last edited:
Upvote 0
What is your code doing with CreateObject?
 
Upvote 0
Solution
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
 
Upvote 0

Forum statistics

Threads
1,224,820
Messages
6,181,159
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top