Macro compatibility from windows office to mac office

[f.dewisme]

Hi,
I have created a file on excel on a pc running windows and office 2003.
The file is supposed to be used by some collegues which have mac
equiped with office pack for Mac 2004.
The file is an excel file containing many macro and userforms. It works
very well on my pc as well as on other PCs but when i opened the file
on a mac, problems started to arrise.
Problems met:
1: graphic... converting metafiles while it´s opening the file
2: When the file finishes to load then error mesage pops up :
"Microsoft Visual Basic Editor: Unable to create embeded objects"
3: After I click OK the file is open however I have some objectss on
the spreadsheets that are linked to some macro. When I clicked of one
of the object then I get this error mesage
" "Run time error 57121" Can´t exit design mode because Control
´CommandButton!´can not be created.
4: Most of the macros I did contain some code like: "
Sheets(Sheet1).select for exemple, which is pretty basic code. This
code doesn´t work with the MAC office VBA it says error 9 ... I can
just have some code like sheets(1).select. Is their a solution for that
Finally
5: Most of my user forms are empty in my file when I open them on the
mac.
Am I screw or there are solutions for my problems
I defintly need some explainations or advices whcih None of Microsoft
neither Mactopia are abble to give on their website for free.
That´s pretty lame customer service.
When some brands develop some products which are supposed to be the
same and they know that they are troubleshooting, the minimum they
could do is to provide free support.
Thank you

 

[Bob Greenblatt]

Hi,
I have created a file on excel on a pc running windows and office 2003.
The file is supposed to be used by some collegues which have mac
equiped with office pack for Mac 2004.
The file is an excel file containing many macro and userforms. It works
very well on my pc as well as on other PCs but when i opened the file
on a mac, problems started to arrise.
Problems met:
1: graphic... converting metafiles while it´s opening the file

What kind of embedded graphics are you using. I often see this when opening
windows files, but the graphic usually appears more or less correctly.

2: When the file finishes to load then error mesage pops up :
"Microsoft Visual Basic Editor: Unable to create embeded objects"

What kind of Objects are present? Remember that the Macintosh does not
support Active X controls or objects.

3: After I click OK the file is open however I have some objectss on
the spreadsheets that are linked to some macro. When I clicked of one
of the object then I get this error mesage
" "Run time error 57121" Can´t exit design mode because Control
´CommandButton!´can not be created.

Is your macro trying to create controls on a form during run time? Post the
code and we can help. (Unless it is an active x control which will not
work.)

4: Most of the macros I did contain some code like: "
Sheets(Sheet1).select for exemple, which is pretty basic code. This
code doesn´t work with the MAC office VBA it says error 9 ... I can
just have some code like sheets(1).select. Is their a solution for that
Finally

Well, yes, it is pretty basic code, and does indeed work correctly in MAC
office VBA. Bear in mind that it is almost NEVER necessary, and is a poor
coding practice to select a sheet. The error 9 means the object is not
properly qualified. What is the rest of your code prior to this statement.
How is the sub containing it entered?

5: Most of my user forms are empty in my file when I open them on the
mac.
Am I screw or there are solutions for my problems
I defintly need some explainations or advices whcih None of Microsoft
neither Mactopia are abble to give on their website for free.

Your user forms are probably empty because you are trying to use active x
controls which do not work. Design your forms using the tools on the forms
tool bar.

That´s pretty lame customer service.
When some brands develop some products which are supposed to be the
same and they know that they are troubleshooting, the minimum they
could do is to provide free support.

Who ever said they are supposed to be the same? Microsoft has always clearly
stated that there are different products for Windows and Macintosh. Yes,
they are similar and present a pretty common user interface, but there are
differences. The application help files and particularly VB help describes
some of these differences.

 

[f.dewisme]

Hi,
Thanks to your answer.
I´ll try to give you as much details as I can to make myself clear.

What kind of embedded graphics are you using. I often see this when opening
windows files, but the graphic usually appears more or less correctly.

I agree for this one. And this is the less of my problems

What kind of Objects are present? Remember that the Macintosh does not
support Active X controls or objects.

The objects presents are just some shapes I have created on my excel
file running on windows using the drawing toolbox. I don´t know about
active X controls or objects.

Is your macro trying to create controls on a form during run time? Post the
code and we can help. (Unless it is an active x control which will not
work.)

The macro linked to the object is just a 2Show UserForm" macro

4: Most of the macros I did contain some code like: "

Well, yes, it is pretty basic code, and does indeed work correctly in MAC
office VBA. Bear in mind that it is almost NEVER necessary, and is a poor
coding practice to select a sheet. The error 9 means the object is not
properly qualified. What is the rest of your code prior to this statement.
How is the sub containing it entered?

For this one I´m kind of mute. Actually, As soon as my macro refers to
a specific sheet, meaning that I refer to the name of the sheet as for
exemple Sheets("Sheet1").Range("A1:B1") Then i get an error mesage.
like for exemple I just copy one code of a sub which work perfectly on
my PC and doesn´t work under MAC.
Sub Antal_Salg()

Dim y As Integer
Dim i As Integer
Dim x As Integer
For i = 3 To Sheets.Count Step 1
y = 445
For x = 12 To 225 Step 1
Sheets("Overall").Cells(y, i + 1).Value =
Sheets(i).Cells(x, "E")
y = y + 1
Next x
Next i

Your user forms are probably empty because you are trying to use active x
controls which do not work. Design your forms using the tools on the forms
tool bar.

I think the problem might come from the fact that there is an image in
the background of the userform. I red somewhere that I should use only
BMP format for image in user form. I´ll try it

Who ever said they are supposed to be the same? Microsoft has always clearly
stated that there are different products for Windows and Macintosh. Yes,
they are similar and present a pretty common user interface, but there are
differences. The application help files and particularly VB help describes
some of these differences.

I didn´t mean to be rude but I´m pretty frustrated at this point.

I definitly appriciate your attention and the patience to answer my
questions
By the way if it could help, I can send you a copy of this excel file
if you want to try it on your system

 

[Bob Greenblatt]

I definitly appriciate your attention and the patience to answer my
questions
By the way if it could help, I can send you a copy of this excel file
if you want to try it on your system

Yes, send me a copy of the workbook and I'll take a look at it.