- Jan 15, 2008
I have some budget tools that we run in our organization using Excel. Some of these are heavily macro-driven, and to further complicate things, some of those use Windows API to achieve some of the functionality. I recently discovered that a large number of users in our company are using some kind of Mac-based system, with the corresponding version of Office for Mac installed. This was news to me. This created huge compatibility headaches for our users, as they were not able to use their own workstation to run our tools, and had to line up at a limited number of Windows workstations to complete the Budget process.
I have not yet been able to get a Mac-based workstation to test some of our tools, so I don't know all of the specifics, but want to see if anyone has any insight into cross-platform development and porting Windows-reliant spreadsheets to Mac versions of Excel.
Problem #1: some of our tools rely on Windows API. We are using libraries such as kernel32.dll, user32.dll, shfolder.dll, and advapi32.dll. My assumption is that none of this works on Mac operating systems. Is there some equivalent of achieving these functions (GetUserName, GetComputerNameEx, GetSystemMetrics, SHGetFolderPath, etc) to recover some of this functionality? We can definitely nix some of it, but certain ones would be hard to live without, given our current setup, without reinventing the wheel.
Problem #2: this one is less of a concern, but are there any known VBA compatibility issues, using strictly built-in VBA and Excel object model, when porting Windows version to Mac? Particularly curious whether VBA Forms would still work.
Problem #3: even less of a concern, but are there any known compatibility issues with native Excel functions, when porting Windows to Mac? I am interested in a broad range of things, from worksheet functions to Worksheet properties (e.g. protection), to file formats, and so on.
If anyone has any insight, or if there are online/book resources available that address these issues, I would love to know!
Thank you for looking, and thanks in advance for any help or advice.
Vba For Mac Excel Templates
I developed a macro/VBA script in Excel (running on wondows) and need to implement it on my customer's machine who has a mac book. Diamond for mac. I had to change the file path (obviously) but the other change needed is the format in which apple recognises path. Enabling file access on Excel 2016 for macs. In the 2016+ versions of Excel, VBA operates in a sandbox which means that explicit permission has to be granted if any files are to be opened. This is not required if the file has been identified with a appleScript 'fileopen dialog box.