Developet a set of two spreadsheets on PC. Data transfer from one to the
other is done with a button having a VB-sub that does the transfor. All work
well on PC.

BUT when attempting the same on MAC (withe same set) a click on button
generate an error "... format mismatch..." . I am frustrated, why on MAC and
not on PC !?

Mac XL VBA is VBA5 (equivalent to WinXL97). I'm not familiar with that
error (perhaps "type mismatch"?), but there are several differences,
among them:

1) MacXL does not do ActiveX controls (ActiveX is Win only).
2) MacXL doesn't do VBA6 functions (e.g., Split, Join)
3) There are a few platform specific differences, such as the FileType
argument in the GetOpenFileName() method.
4) WinXL doesn't do AppleScript scripting using MacScript.

You might find more help at the microsoft.public.mac.office.excel
newsgroup. Be sure to post the code that's throwing the error.


In article ,
cre wrote:

Developet a set of two spreadsheets on PC. Data transfer from one to the
other is done with a button having a VB-sub that does the transfor. All work
well on PC.

BUT when attempting the same on MAC (withe same set) a click on button
generate an error "... format mismatch..." . I am frustrated, why on MAC and
not on PC !?