VB in Excel: PC to Mac problems

[Jeff Melkonian]

Hi,
I wrote some vb code using Excel 2002. A user tried
running the code in Excel for Mac (PowerBook G4 with OS X)
and got the following error message: "Compile error in hidden

module: ThisWorkbook". Does anyone know how to fix this

error and, more generally, what other problems might occur
when trying to run vb code on a Mac when that code was
developed in Excel 2002?

Thanks,

Jeff Melkonian
..

 

[JE McGimpsey]

MacXL uses VBA 5, so any VBA6 commands you use, you'll either need to
add in (conditional compilation) or rewrite.

MacXL doesn't support ActiveX. Replace ActiveX controls with controls
from the Forms toolbar.

There are a few syntax differences, mostly in the File I/O area (e.g.,
the FileFilter property of the GetOpenFileName method).

Hi,

I wrote some vb code using Excel 2002. A user tried
running the

code in Excel for Mac (PowerBook G4 with OS X) and got the following error
message: "Compile error in hidden
module: ThisWorkbook". Does anyone know
how to fix this

error and, more generally, what other problems might occurwhen trying to run vb code on a Mac when that code was
developed in Excel

2002?

Thanks,

Jeff Melkonian