can an excel file compiled on a Windows PC be used on a Mac computer?

A

aaronep

Can an Excel data file compiled on a PC be read by a Mac computer with
Mac version of Excel?
And vice-versa? best, Aaron
 
J

JE McGimpsey

Yes, with a few caveats, among them:

1) There are some (not many) differences in the way VBA commands are
implemented on both platforms (e.g., the GetOpenFileName method).

2) Mac VBA is version 5, so VBA6 commands won't compile in MacXL (I
conditionally compile replacement routines in my cross-platform apps).

3) ActiveX is a Windows-only technology, so ActiveX controls will not
function in MacXL.

4) UserForms are always modal in MacXL.
 
J

JLGWhiz

Good info JE, I didn't think he asked about the VBA part but it don't hurt to
throw that in too.
 
J

JE McGimpsey

JLGWhiz said:
Good info JE, I didn't think he asked about the VBA part but it don't hurt to
throw that in too.
Click to expand...

Well, it *is* the programming group after all... <g>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing Excel 365 Mac<->PC 0
Excel file won't save to iCloud on Mac 0
How to insert Certificated digital signature in Word for Mac 0
Can't send emails on new PC 1
Mis-performing MP4 files in Mac PPT 1
Documents Not Appearing (as it used to) On Desktop ? [on a Mac] 0
Mac Excel compile error method or data member not found 0
open office data file compiled with a mac computer readable with a pc? 1

Top