Running Windows based Excel Application on a Mac

**ravichander** · 04-22-2011, 08:03 PM

Hi all:

I have an application that was developed using Windows Excel 2007 and uses VBA. Here are a couple of questions:

1. Will the existing application run on a Mac (Apple OS)?
2. If it will not, what needs to be done to the existing application to make it work on a Mac?

Thank you for you kind assistance.

- Ravi

**ravichander** · 04-30-2011, 01:14 PM

I thought I'd bring this thread back up. Bump.

**martindwilson** · 04-30-2011, 02:04 PM

probably depends on version of excel on the mac

**ravichander** · 05-01-2011, 01:09 AM

Hi Martin:

Thank you for your kind response.

Does that mean, an Excel application developed on Windows OS will not work on a Mac? And that a Mac Version of the Excel application would have to be developed?

Thanks.

**martindwilson** · 05-01-2011, 06:20 AM

i think you'd be better of google-ing this question ,some versions of windows for mac did not support vba.
so you need to check exactly what you have. i don't have a mac and never will so i cant help you more than that, However there are members on this forum who use macs and they may know more,

**Andy Pope** · 05-01-2011, 06:20 AM

As Martin said it depends.
VBA on the mac has only recently been reinstated. xl2008, I think that's the version, had no VBA and apple script was requried for automation.

There is also a VBA version difference between xl2004 (v5.0) and xl2011 (v6.5)

And of course it will depend greatly on what the vba is actually doing.

**ravichander** · 05-01-2011, 07:38 PM

Thank you both, Martin and Andy, for your response.

The VBA code executes everything from moving from one screen to another in the application, as well as developing graphs based on the data presented.

I had one ohter person (not from this forum) suggest OpenOffice Calc also.

- Ravi

**royUK** · 05-02-2011, 04:02 AM

OpenOffice VBA is worlds apart from MS Excel VBA

**ravichander** · 05-03-2011, 01:23 PM

Hi Roy:

Thank you for your kind response. So OpenOffice is not viable either, in the sense that moving to OpenOffice would still require a re-write of the entire application.

One thought is, can the MS Excel application be run on any browsers? Thanks.

- Ravi