Excel VBA for Mac

I need to develop an Excel VBA application that is compatible with Mac OS. Can anyone tell me what the differences are, or help me find a reference or book that explains VBA for Mac?

thx
LVL 1
DavisroBudget AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kanti PrasadCommented:
Hi

As long as you have excel you will be VBA with it. The excel macros are VBA code only but many features are only available in VBA through Windows COM components (like regular expressions, collections, dictionaries, the file system object etc) and all these features may not be available in a Mac version.

Please look at the below link
http://www.easyexcelvba.com/introduction.html
http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macword/vba-support-on-office-mac/5023cdbc-fadf-4e39-a49f-59d2534aef85
strungCommented:
Here is a pretty comprehensive guide to the differences between the Mac and Windows versions of Excel:

http://www.rondebruin.nl/mac.htm
Eoin OSullivanConsultantCommented:
Ron

The short answer is that you CANNOT develop a VB Application on Excel for OSX.   You can include visual basic scripts within an Excel spreadsheet but they are limited to performing functions within Excel itself and some very basic filesystem calls.  

Basically Microsoft Excel is a lot more limited on OSX than it is on Microsoft's own OS Windows .. short and sweet.

If you want to outline what specifically you are trying to do in VB we may be able to indicate if it is possible in other ways or fits within the limits of VB in Excel on OSX.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DavisroBudget AnalystAuthor Commented:
Attached are the templates.

The Mac version has the ActiveX Objects removed and a modified verion of Ron DeBruin's Applescript code. I haven't been able to test it yet on a Mac but I'll be getting a loaner from IT.

Notes:
1. We have one department that only has Mac desktops deployed, with Excel 2011 for Mac. BUT, people occasionally people use their own laptops as well and I've no idea what version they may attempt to use.

2. The one thing I'd like to do in the Mac version (besides getting it to work) is being able to query the username from the email client so I can include it in the timestamp the gets written under the Send Timesheet button
Timesheet-Template-EE-FY15-16.xlsm
Timesheet-Mac-EE-FY15-16.xlsm
Martin LissOlder than dirtCommented:
I've requested that this question be closed as follows:

Accepted answer: 250 points for kantiprasad's comment #a40935104
Assisted answer: 250 points for eoinosullivan's comment #a40935442

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.