Link to home
Start Free TrialLog in
Avatar of Davisro
DavisroFlag for United States of America

asked on

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
SOLUTION
Avatar of Kanti Prasad
Kanti Prasad

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Eoin OSullivan
Eoin OSullivan
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Davisro

ASKER

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
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.