software

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 quot;... format mismatch...quot; . 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 quot;type mismatchquot;?), 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 gt;,
cre gt; wrote:

gt; Developet a set of two spreadsheets on PC. Data transfer from one to the
gt; other is done with a button having a VB-sub that does the transfor. All work
gt; well on PC.
gt;
gt; BUT when attempting the same on MAC (withe same set) a click on button
gt; generate an error quot;... format mismatch...quot; . I am frustrated, why on MAC and
gt; not on PC !?