Link to home
Start Free TrialLog in
Avatar of sccomputers
sccomputers

asked on

Microsoft Visual Basic Compile Error in hidden module: AutoExec

I have Office 2003 installed on my Windows XP machine.
Every time I open an Office App.  I get a Microsoft Visual Basic Error Box, 'Compile Error in hidden module: AutoExec'
I looked at documentation on this site but nothing worked.
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Is this an Access application, or does this occur in all Office products (Word, Excel, etc.)

If Access, hit {f11} to go to your Database Windows, then Tools menu: Options, View tab, check the Hidden Objects checkbox, and hit ok.
Then click on the Macros tab, and you should see a semi-greyed-out AutoExec macro.
Open it in design view, and tell us what it says.
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sccomputers
sccomputers

ASKER

I removed the pdfmaker.dot file from Office /  Startup folder.
I found the one for Excel in the  C:\Documents and Settings\User Name\Application Data\Microsoft\Excel\Xlstart and removed it but I still get the error, only in Excel though.  All other Office Apps. open without an error now.
I ended up just removing Adobe Standard 6.0 and that went away.
Learn something new every day.

Once I found out that a certain version of Macromedia DreamWeaver laid claim to the .asp extension, which cause all of our Web pages to open in DreamWeaver.  (or was it Adobe?)
I used Acrobat 5 instead of 6, but it installed an add-in in my C:\Program Files\Microsoft Office\Office11\XLSTART folder (for Excel) and in C:\Program Files\Microsoft Office\Office11\STARTUP (for Word). Both of these files needed to be removed to enjoy error-free use of Excel and Word.

To produce a .pdf file, my process was to do a "print to file" using a PostScript printer (such as the Apple LaserWriter, which I never owned but found that Windows would install the driver if asked nicely). I could then use Acrobat Distiller to convert that print file into a .pdf document.