vba

I have to call a file in VBA and I'm struggling.

I have recently got a MacBook Pro 2018 now running Mojave. I will need to develop VBA in Microsoft Excel for use by someone else on a Windows 10 machine. I am wondering would there be any issues if I write the codes in a Windows 10 instance installed on my Mac in a Bootcamp partition? Or, it...

Hi there. As you may know, Excel on Mac is very different from Excel on Windows. The issue is not just that it has different interfaces between the two OS. I'm talking about functionalities. I can't do things, sometimes it looks like are two different programmes, shortcuts are different, etc...

I'm trying to make a script of sorts, to copy from the currently selected cell of Excel:Mac, then paste into a VMWare Windows 7 command window that's already open. I tried VBA with 'appactivate' to try to select the command window by name, then was gonna do sendkeys to paste: no joy yet (would...

Hello - Looking for recommendations on Emulators that I can use on My Mac. I have a iMac running OSX El Capitan. I have alot of work spreadsheets (from my PC) with vba macros that I would like to run on my home mac. Recently got excel 2016 for mac but was sadly disappointed when there was...