Excel from Windows to Mac

[John]

Hi all. I need to open an Excel program, written with the Windows
version of Excel, on my Mac. This program is full of macros and other
stuff, and Office for Mac just screws it up- it can be opened, but
that's about it! I have Office X 10.1.5 on my Mac running Jaguar. I
think the Excel program was written using "version 4.0"?. Other than
buying Excel and installing it on Virtual PC, does anyone have any
suggestions?

Thanks..

 

[Kenji]

John,
I just went through this problem. My users were not willing to install
Virtual PC on their macs so I had to modify the code ( A LOT of code) so it
worked on the mac. What kind of activity are you doing on the excel sheet?

Kenjiro Yagi

 

[JE McGimpsey]

Hi all. I need to open an Excel program, written with the Windows
version of Excel, on my Mac. This program is full of macros and other
stuff, and Office for Mac just screws it up- it can be opened, but
that's about it! I have Office X 10.1.5 on my Mac running Jaguar. I
think the Excel program was written using "version 4.0"?. Other than
buying Excel and installing it on Virtual PC, does anyone have any
suggestions?

Macros in WinXL and MacXL are 95% compatible. Unfortunately, sometimes
the 5% gets esoteric.

The big items:

Macs do not do ActiveX. Any ActiveX control will not work in MacXL.

I/O syntax is a little different.

All Mac versions use VBA5 (equivalent to WinXL97). VBA6 code will have
to be conditionally compiled, or separate routines added to implement
the VBA6 functions.

Windows API calls will obviously not work.


I make part of my living writing cross-platform compatible code - it can
be done. If you post back with more description I'm sure we can sort
things out.

 

[John]

Macros in WinXL and MacXL are 95% compatible. Unfortunately, sometimes
the 5% gets esoteric.

The big items:

Macs do not do ActiveX. Any ActiveX control will not work in MacXL.

I/O syntax is a little different.

All Mac versions use VBA5 (equivalent to WinXL97). VBA6 code will have
to be conditionally compiled, or separate routines added to implement
the VBA6 functions.

Windows API calls will obviously not work.


I make part of my living writing cross-platform compatible code - it can
be done. If you post back with more description I'm sure we can sort
things out.

Thanks for your reply.

The program is an Excel Workbook. Upon opening the workbook, a bunch
of metafiles are opened/converted, then I'm presented with an "Compile
Error in Hidden Module: OrBoProModule". I can click "ok". I'm
presented with the face sheet, which looks identical to the Windows
program (I tried working with it on a Windows computer). There are
many graphics, and "links" to scripts (it's a patient case-list
program, where I need to collect data of patient information, organize
it, and print it out in a certain format). None of the scripts seem
to work, meaning if I press on one of the graphics (say, the "Edit
candidate data" button, where I input my name, ID #, etc), I'm
presented with the proper window opening, but any information I type
in is not accepted, and when I press the "ok" button, I'm presented
with a "Runtime error '57121'" "Can't exit design mode because Control
'chkProtect' cannot be created". Each button that I press on gives me
a similar error message. There are a few buttons that present a
window which is supposed to list a variety of categories from which I
can choose, but none of the categories shows up in the window (I only
know this because it works on the Windows computer). I also can't
save anything, and the only way to exit the program is to close the
window with the red widget in the upper left hand corner. Basically,
it looks decent, but I just can't run anything.

Any suggestions?

btw, the company that wrote the program is interested in coming up
with a Mac compatible version...

 

[JE McGimpsey]

The program is an Excel Workbook. Upon opening the workbook, a bunch
of metafiles are opened/converted, then I'm presented with an "Compile
Error in Hidden Module: OrBoProModule". I can click "ok". I'm
presented with the face sheet, which looks identical to the Windows
program (I tried working with it on a Windows computer). There are
many graphics, and "links" to scripts (it's a patient case-list
program, where I need to collect data of patient information, organize
it, and print it out in a certain format). None of the scripts seem
to work, meaning if I press on one of the graphics (say, the "Edit
candidate data" button, where I input my name, ID #, etc), I'm
presented with the proper window opening, but any information I type
in is not accepted, and when I press the "ok" button, I'm presented
with a "Runtime error '57121'" "Can't exit design mode because Control
'chkProtect' cannot be created". Each button that I press on gives me
a similar error message. There are a few buttons that present a
window which is supposed to list a variety of categories from which I
can choose, but none of the categories shows up in the window (I only
know this because it works on the Windows computer). I also can't
save anything, and the only way to exit the program is to close the
window with the red widget in the upper left hand corner. Basically,
it looks decent, but I just can't run anything.

You've probably got VBA6 code (the Compile Error) and you've got ActiveX
controls (the controls that don't work and the ones that can't be
created).

Any suggestions?

Change ActiveX controls to Form controls, and use Conditional
compilation to work around the VBA6 stuff (e.g., if the code uses
Replace(), do a conditional compile with a VBA 5 substitute version of
Replace() if the code is run on a Mac).

btw, the company that wrote the program is interested in coming up
with a Mac compatible version...

I'm currently accepting contracts...

http://www.mcgimpsey.com/ma/consulting.html

 

[John]

Hi Kenjiro,

A summary of the stuff I'm doing can be found at www.exampro.com. I'm
preparing a caselist of patients (data from patient history, medical
history, etc., which needs to be printed out in a certain format and
handed in). I'd appreciate any help that you can give. If you need
any more info, please feel free to contact me. Thanks...