Everyone:
Just a note of caution... While Adobe's PDFMaker is a notorious source of
irritation, it's not the only thing that "could" produce that error.
Visual Basic for Applications compiles at run-time, so you can conceivably
get this error when you first attempt to RUN any macro that has been coded
for PC Word, particularly the later versions.
If the offending module is not encrypted, Word will start a debugger which
will attempt to show you where the error is. However, if the vendor has
locked their code (as Adobe does) Word can't display the code so you get the
infuriating "Compile Error in Hidden Module". In Adobe's case, their coding
problem is in a module named "AutoExec".
AutoExec is a reserved macro name that causes Word to run the macro so named
every time it starts up, which is why we tend to find out about Adobe's
little problems immediately.
I would argue (some would say "rant"...) about PDFMaker's basic design. The
thing runs EVERY time Word starts up. It doesn't need to: once would be
sufficient. Because it runs every time, it changes your toolbars every
time, which eventually breaks your Normal template. Not a good design...
Because Adobe relies on an "Auto" macro, and you can have only one of those
operating at a time, they manage to interfere with the user's Auto macros,
which leads to a lot of time-consuming bug-hunting until you finally realise
that the reason YOUR macro doesn't run is that Adobe has one with the same
name in a hidden module you can't see. Not a kind thing to do to users...
And finally, there is no excuse for a company of Adobe's size publishing VBA
that generates compile errors. VBA supports conditional compilation, and
it's a trivial matter to code a macro so that it compiles and runs correctly
on any Microsoft Word platform. I know this because I have to do it: parts
of my macros require different code between Word 2000 and Word 2003.
</Rant>
THANK YOU, THANK YOU, THANK YOU!
I came here to find out about this irritating error on quitting Excel,
but that PDFMaker in Word has bugged me for ages too. It insists on
floating below the other toolbars, and won't remember that I want it to
the right on the same level. I therefore always have new documents open
smaller and lower than I want.
I am now FREE of that stupid tool that I never used and always got in
the way!
--
Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.
John McGhie <john@mcghie.name>
Consultant Technical Writer
Sydney, Australia +61 4 1209 1410