Windows excel file not running on Mac Excel - Visual Basic e
Discussion
I have an Excel spreadsheet that contains (apparently) Macros and Visual Basic to run.
If I try an run it on Outlook for Mac, it won't work and comes up with Visual Basic errors.
Is it fixable, or do I have to continue to use Parallels, where it has worked fine for several years. However, It has recently started to require an IP print workaround according to the Parallels engineer which is a bit of a faff, hence me considering dumping Parallels. Apparently Apple have stopped supporting postscript printer drivers which must F up sevral million printers, or am I missing something?
If I try an run it on Outlook for Mac, it won't work and comes up with Visual Basic errors.
Is it fixable, or do I have to continue to use Parallels, where it has worked fine for several years. However, It has recently started to require an IP print workaround according to the Parallels engineer which is a bit of a faff, hence me considering dumping Parallels. Apparently Apple have stopped supporting postscript printer drivers which must F up sevral million printers, or am I missing something?
I assume you mean Office for Mac, and not Outlook for Mac, and VBA doesn't work in Outlook.
What version do you have on the Mac? Is it the standalone apps run from the Mac, or the cloud-based version?
VBA should work on the Mac versions, with a few caveats (mainly around anything that reference Windows-specific / Microsoft Runtime calls).
As for the postscript printer deprecation, I don't see why you can't use a non-postscript driver for IP printing...or just share the Mac printer within Parallels?
What version do you have on the Mac? Is it the standalone apps run from the Mac, or the cloud-based version?
VBA should work on the Mac versions, with a few caveats (mainly around anything that reference Windows-specific / Microsoft Runtime calls).
As for the postscript printer deprecation, I don't see why you can't use a non-postscript driver for IP printing...or just share the Mac printer within Parallels?
I have a high power windows machine specifically for Excel, otherwise develop on a Mac. Lots of advanced functionality is missing from the Mac version of Excel. My firm has quite a few ridiculous ‘spreadsheets’ that are better off coded as custom programs. My usual procedure is to try and fire up the ‘spreadsheet’ on the Mac, if that doesn’t work, get the Windows laptop out.
Edited by wyson on Tuesday 7th November 12:41
Well, yes I have that option, but my venerable windows lappy is a ancient relic, prolly 2010, so It;s only used for an emergency, The quotes I use the spreadsheet for are often done whilst on the phone, so not a great option to say I'll call you back in half an hour when my laptops got going! (And yes, it does have an SSD installed, lol.)
nyt said:
Can you run it on the free online Office365: https://www.microsoft.com/en-gb/microsoft-365/free...
I'll try the online route. I have just bought a new Mac Mini computer and I'd have to buy a special ARM friendly Windows 11 version to run on the Apple silicon based computer. As my subscription to Parallels is due on monday, I have binned Parallels off as too much hassle!
I'll report back.
Thanks for your input chaps.
andygo said:
I have tried the office 365 online route. It didn't work as active X isn't enabled online, has to be a desktop app. I don't want to install office 365 on my Mac.
99% sure that ActiveX isn't available on a Mac. I don't think that ActiveX controls should cause errors in Excel/Web but they may not be visible (not much help, I appreciate)
Do you know what the ActiveX is doing. Is it something that you could live without or substitute?
Feel free to PM me the spreadsheet (or a cut-down version) and I'll take a look - assuming that it's not confidential
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff