Toolbar won't work unless I debug

[kristof.vanbeek]

Hellow there,

I am working for a couple of weeks on Mac now, but I am experiencing a
weird problem. I made some templates in Microsoft Word for PC. In
these templates, there is some VBA code to make it all work properly.
In these code I make a toolbar to change the document at runtime. This
is all working properly on Windows.

Now they asked me to make it run on Mac. So I started testing on Mac.
In the beginning of the template, there are screens who are asking
some input from the user. This is all working properly. After all
those screens, you'll get the document. In this document is also the
same toolbar to change somethings at runtime (letter - memo layout)
(Send by post - fax - mail).

But on Mac, this toolbar isn't working. If I choose something from the
comboboxes, then the right fields aren't filled in. He always sets the
things to letter - Post (standard format). So if I want to send a
letter by mail, the mailadres should appear on the document. But that
isn't working because Word:Mac thinks it should be a letter by post
and then you don't need an e-mailadress.

So I think to myself, I set a breakpoint in the code, so I can debug
the code and see where things go wrong. So far so good, but if I do
this, everything is working fine. All the code he should be running
according to the toolbar. So if I the choose for letter - mail, he is
running the code for this. All is working good then. But if I remove
the breakpoint, it isn't working anymore.

Breakpoint in code again, enters code, working.
Remove breakpoint, running, don't work.

I am running on Mac OS X Version 10.4.10 with a version of Mac:Word
2004

Does anyone have a clue of how this can be fixed, or what's the reason
and if it can be fixed?

 

[John McGhie]

Hi Kristof:

I would need to see your code to be sure. However, Mac Word 2004 has VBA
level 5 (Word 2000).

Word 2003 is VBA 6, and Word 2007 is VBA 6.5. Many commands, properties and
methods available on the PC are not available on the Mac.

In Mac Word 2008, there is no VBA at all.

So I would give up, if I were you: in the next version, there are no macros
at all. So any work you do now will be wasted: the new version is due out
in January.

If I were you, I would create this solution as separate templates, one for
each kind of document. Put them in a folder and tell the users how to
choose them manually.

Sorry.

Hellow there,

I am working for a couple of weeks on Mac now, but I am experiencing a
weird problem. I made some templates in Microsoft Word for PC. In
these templates, there is some VBA code to make it all work properly.
In these code I make a toolbar to change the document at runtime. This
is all working properly on Windows.

Now they asked me to make it run on Mac. So I started testing on Mac.
In the beginning of the template, there are screens who are asking
some input from the user. This is all working properly. After all
those screens, you'll get the document. In this document is also the
same toolbar to change somethings at runtime (letter - memo layout)
(Send by post - fax - mail).

But on Mac, this toolbar isn't working. If I choose something from the
comboboxes, then the right fields aren't filled in. He always sets the
things to letter - Post (standard format). So if I want to send a
letter by mail, the mailadres should appear on the document. But that
isn't working because Word:Mac thinks it should be a letter by post
and then you don't need an e-mailadress.

So I think to myself, I set a breakpoint in the code, so I can debug
the code and see where things go wrong. So far so good, but if I do
this, everything is working fine. All the code he should be running
according to the toolbar. So if I the choose for letter - mail, he is
running the code for this. All is working good then. But if I remove
the breakpoint, it isn't working anymore.

Breakpoint in code again, enters code, working.
Remove breakpoint, running, don't work.

I am running on Mac OS X Version 10.4.10 with a version of Mac:Word
2004

Does anyone have a clue of how this can be fixed, or what's the reason
and if it can be fixed?

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:[email protected]

 

[Jim Gordon MVP]

Hi Kris,

I'm not as pessimistic as McGhie about Office 2008. Many people will simply
skip this version, much as Windows users have done with versions of Office
for Windows for years.

Office 2004 will continue to work for a long time. Because 2004 has VBA and
Office 2008 does not, many thousands of users will not want to or be able to
"upgrade."

The trouble I'm having with your message is that I don't understand what is
meant by "send by mail" vs "send by post."

Is this a mail merge we're talking about?

Thanks.

-Jim

Quoting from "(e-mail address removed)" <[email protected]>, in
article (e-mail address removed),

Hellow there,

I am working for a couple of weeks on Mac now, but I am experiencing a
weird problem. I made some templates in Microsoft Word for PC. In
these templates, there is some VBA code to make it all work properly.
In these code I make a toolbar to change the document at runtime. This
is all working properly on Windows.

Now they asked me to make it run on Mac. So I started testing on Mac.
In the beginning of the template, there are screens who are asking
some input from the user. This is all working properly. After all
those screens, you'll get the document. In this document is also the
same toolbar to change somethings at runtime (letter - memo layout)
(Send by post - fax - mail).

But on Mac, this toolbar isn't working. If I choose something from the
comboboxes, then the right fields aren't filled in. He always sets the
things to letter - Post (standard format). So if I want to send a
letter by mail, the mailadres should appear on the document. But that
isn't working because Word:Mac thinks it should be a letter by post
and then you don't need an e-mailadress.

So I think to myself, I set a breakpoint in the code, so I can debug
the code and see where things go wrong. So far so good, but if I do
this, everything is working fine. All the code he should be running
according to the toolbar. So if I the choose for letter - mail, he is
running the code for this. All is working good then. But if I remove
the breakpoint, it isn't working anymore.

Breakpoint in code again, enters code, working.
Remove breakpoint, running, don't work.

I am running on Mac OS X Version 10.4.10 with a version of Mac:Word
2004

Does anyone have a clue of how this can be fixed, or what's the reason
and if it can be fixed?

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Clive Huggan]

Hi Kris,

I'm not as pessimistic as McGhie about Office 2008. Many people will simply
skip this version, much as Windows users have done with versions of Office
for Windows for years.

Office 2004 will continue to work for a long time. Because 2004 has VBA and
Office 2008 does not, many thousands of users will not want to or be able to
"upgrade."

The trouble I'm having with your message is that I don't understand what is
meant by "send by mail" vs "send by post."

Jim, among non-US English speakers it's common for "mail" and "post" to be
synonymous, and without other qualification to indicate "snailmail", i.e.
that which gets carted around in envelopes by horse-and-buggy, e.g. by US
Postal. ;-)

Clive
=====

 

[Jim Gordon MVP]

Hi,

Then maybe this link will help:
http://www.mcgimpsey.com/macoffice/excel/macexcelsendmail.html

-Jim

Jim, among non-US English speakers it's common for "mail" and "post" to be
synonymous, and without other qualification to indicate "snailmail", i.e.
that which gets carted around in envelopes by horse-and-buggy, e.g. by US
Postal. ;-)

Clive
=====

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info