Running VB macros on Excel for Mac

P

pabloramirez01

Hello,

I am not a VB programmer, just received some macros from a PC friend
that I would like to run on my mac.
I found the followng error:

'Compile error in hidden module : Openexit'
Any ideas on how to deal with it.

Thank you in advance

Pablo
 
J

JE McGimpsey

I am not a VB programmer, just received some macros from a PC friend
that I would like to run on my mac.
I found the followng error:

'Compile error in hidden module : Openexit'
Any ideas on how to deal with it.
Click to expand...

The macro was probably written using VBA6 functions (WinXL2000+), but
it's hard to tell without seeing the code. All Mac Office versions use
VBA5 (equivalent to WinOffice97)

When you get the error message, do you also get taken to the offending
line in the VBE? if so, post that code and it will probably be obvious.
 
Top