Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
arjay
 
Posts: n/a
Default Compile error in hidden module

Every time I start Excel (in Office 2003 Pro)I get an error message in
a box headed Visual Basic that says Compile error in hidden
module:AutoExecNew.

Whe I close it I get the error Compile Error in hidden module:DistMon

I tried removing the only .xlb file, but it seemed to do nothing.

I would uninstall Excel and reinstall it if I could figure out how to
do so. Any suggestions for fixing the problem or how to uninstall
Excel. I cannot uninstall it from the Add Remove Programs in Control
Panel.

Thanks

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Take a look he

http://support.microsoft.com/default...;EN-US;q307410
OFF: "Compile Error in Hidden Module" Error Message When You Start
Word or Excel

It points at PDFMaker.xla as being the culprit.

arjay wrote:

Every time I start Excel (in Office 2003 Pro)I get an error message in
a box headed Visual Basic that says Compile error in hidden
module:AutoExecNew.

Whe I close it I get the error Compile Error in hidden module:DistMon

I tried removing the only .xlb file, but it seemed to do nothing.

I would uninstall Excel and reinstall it if I could figure out how to
do so. Any suggestions for fixing the problem or how to uninstall
Excel. I cannot uninstall it from the Add Remove Programs in Control
Panel.

Thanks


--

Dave Peterson
  #3   Report Post  
SunTaxMan
 
Posts: n/a
Default

Dave Peterson,

I am having same problem with DistMon and AutoExecNew. I found this string
and followed instructions. What I found was an XLStart folder, but not an
XLStart file. I moved XLStart Folder out of Excel on to Desktop and then
Excel (part of MS Office 2003) would not start.

Can you offer, or any other users, offer some assistance?

I have recently UNinstalled Adobe Acrobat 5.0, after installing MS Office
2003 (I had been using MS OFfice 2000). I did NOT seek any residual Acrobat
files and manually delete them. Is this something I should do? Could this be
part of the problem?

"Dave Peterson" wrote:

Depending on your upgrade path through excel, you could have multiple XLStart
folders.

I'm still betting my money that you have that addin in one of those XLStart
folders.

Close excel
windows start button|search/find
look for pdf*.xla (just in case the name isn't always the same)

If (when!) you find it, move it somewhere else and see what happens when you
start excel the next time.



Sammie wrote:

OK, just to check: I go tools, add-ins, and nothing is checked.
Nothing is in my XLstart folder.
Thanks for any more new ideas.
Sammie

"Frank Kabel" wrote:

Hi
if you have disabled all your addins (and you may double-check this)
also check if you have any files in your XLStart folder

--
Regards
Frank Kabel
Frankfurt, Germany


Sammie wrote:
Nope - this is the kb article I already tried with no joy. I need a
new suggestion. What is autoexecnew and distmon? Is there a visual
basic hidden module? I have disabled all my add-ins. This problem
isn't a show-stopper, but it's been going on for months and it's very
annoying. I will appreciate new ideas. Thanks. Sammie

"Dave Peterson" wrote:

maybe:

http://support.microsoft.com/default...;EN-US;q307410
OFF: "Compile Error in Hidden Module" Error Message When You Start
Word or Excel

It points at PDFMaker.xla as being the culprit.

Sammie wrote:

Every time I open Excel 2003, I get the error: "compile error in
hidden module: AutoExecNew" and on closing, I get the error:
"compile error in hidden module: DistMon". I have read your
knowledge base article on the subject and also searched newsgroups.
Recommended solutions all point to pdfmaker.xla. I have already
deleted all the pdfmaker files but I still get the errors. What
next? Thanks. Sammie

--

Dave Peterson



--

Dave Peterson

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

Put the folder back, but move the addins to a different location--or if you'll
never use them, delete them.

SunTaxMan wrote:

Dave Peterson,

I am having same problem with DistMon and AutoExecNew. I found this string
and followed instructions. What I found was an XLStart folder, but not an
XLStart file. I moved XLStart Folder out of Excel on to Desktop and then
Excel (part of MS Office 2003) would not start.

Can you offer, or any other users, offer some assistance?

I have recently UNinstalled Adobe Acrobat 5.0, after installing MS Office
2003 (I had been using MS OFfice 2000). I did NOT seek any residual Acrobat
files and manually delete them. Is this something I should do? Could this be
part of the problem?

"Dave Peterson" wrote:

Depending on your upgrade path through excel, you could have multiple XLStart
folders.

I'm still betting my money that you have that addin in one of those XLStart
folders.

Close excel
windows start button|search/find
look for pdf*.xla (just in case the name isn't always the same)

If (when!) you find it, move it somewhere else and see what happens when you
start excel the next time.



Sammie wrote:

OK, just to check: I go tools, add-ins, and nothing is checked.
Nothing is in my XLstart folder.
Thanks for any more new ideas.
Sammie

"Frank Kabel" wrote:

Hi
if you have disabled all your addins (and you may double-check this)
also check if you have any files in your XLStart folder

--
Regards
Frank Kabel
Frankfurt, Germany


Sammie wrote:
Nope - this is the kb article I already tried with no joy. I need a
new suggestion. What is autoexecnew and distmon? Is there a visual
basic hidden module? I have disabled all my add-ins. This problem
isn't a show-stopper, but it's been going on for months and it's very
annoying. I will appreciate new ideas. Thanks. Sammie

"Dave Peterson" wrote:

maybe:

http://support.microsoft.com/default...;EN-US;q307410
OFF: "Compile Error in Hidden Module" Error Message When You Start
Word or Excel

It points at PDFMaker.xla as being the culprit.

Sammie wrote:

Every time I open Excel 2003, I get the error: "compile error in
hidden module: AutoExecNew" and on closing, I get the error:
"compile error in hidden module: DistMon". I have read your
knowledge base article on the subject and also searched newsgroups.
Recommended solutions all point to pdfmaker.xla. I have already
deleted all the pdfmaker files but I still get the errors. What
next? Thanks. Sammie

--

Dave Peterson



--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
SunTaxMan
 
Posts: n/a
Default

I am puzzled. "pdf Maker" is the ONLY file in the folder. Should there be
more than that present in this folder?

In any case, I moved the "pdf Maker" file out of the SLStart folder (put it
on the desktop, in case I need it) and Excel seems to be working fine.

Thanks,

While I am on a roll. I have investigated the User Group sites and see no
method of "subscribing" (or whatever term MS uses) so I would be notified of
new posts to the site - not just replies to my posts. It would seem to be
beneficial to monitor all posts, in some specific software areas, at least,
in order to both learn and be able to share my "learnings" with other. I have
sent an inquiry to MS about this, but have received no adequate response as
yet. Can you point me in the right direction?

"Dave Peterson" wrote:

Put the folder back, but move the addins to a different location--or if you'll
never use them, delete them.

SunTaxMan wrote:

Dave Peterson,

I am having same problem with DistMon and AutoExecNew. I found this string
and followed instructions. What I found was an XLStart folder, but not an
XLStart file. I moved XLStart Folder out of Excel on to Desktop and then
Excel (part of MS Office 2003) would not start.

Can you offer, or any other users, offer some assistance?

I have recently UNinstalled Adobe Acrobat 5.0, after installing MS Office
2003 (I had been using MS OFfice 2000). I did NOT seek any residual Acrobat
files and manually delete them. Is this something I should do? Could this be
part of the problem?

"Dave Peterson" wrote:

Depending on your upgrade path through excel, you could have multiple XLStart
folders.

I'm still betting my money that you have that addin in one of those XLStart
folders.

Close excel
windows start button|search/find
look for pdf*.xla (just in case the name isn't always the same)

If (when!) you find it, move it somewhere else and see what happens when you
start excel the next time.



Sammie wrote:

OK, just to check: I go tools, add-ins, and nothing is checked.
Nothing is in my XLstart folder.
Thanks for any more new ideas.
Sammie

"Frank Kabel" wrote:

Hi
if you have disabled all your addins (and you may double-check this)
also check if you have any files in your XLStart folder

--
Regards
Frank Kabel
Frankfurt, Germany


Sammie wrote:
Nope - this is the kb article I already tried with no joy. I need a
new suggestion. What is autoexecnew and distmon? Is there a visual
basic hidden module? I have disabled all my add-ins. This problem
isn't a show-stopper, but it's been going on for months and it's very
annoying. I will appreciate new ideas. Thanks. Sammie

"Dave Peterson" wrote:

maybe:

http://support.microsoft.com/default...;EN-US;q307410
OFF: "Compile Error in Hidden Module" Error Message When You Start
Word or Excel

It points at PDFMaker.xla as being the culprit.

Sammie wrote:

Every time I open Excel 2003, I get the error: "compile error in
hidden module: AutoExecNew" and on closing, I get the error:
"compile error in hidden module: DistMon". I have read your
knowledge base article on the subject and also searched newsgroups.
Recommended solutions all point to pdfmaker.xla. I have already
deleted all the pdfmaker files but I still get the errors. What
next? Thanks. Sammie

--

Dave Peterson



--

Dave Peterson


--

Dave Peterson



  #6   Report Post  
Dave Peterson
 
Posts: n/a
Default

There doesn't have to be.

I have 3 files in my XLStart
#1. Book.xlt
#2. Sheet.xlt
#3. Personal.xla

The first is a template that excel uses when I create a new workbook by clicking
on the New icon on the standard toolbar.

The second is a template that excel uses when I add a worksheet to an existing
workbook.

The third is where I keep all my macros and user defined functions. (Some
people use personal.xls.)

There can be more here, too.



SunTaxMan wrote:

I am puzzled. "pdf Maker" is the ONLY file in the folder. Should there be
more than that present in this folder?

In any case, I moved the "pdf Maker" file out of the SLStart folder (put it
on the desktop, in case I need it) and Excel seems to be working fine.

Thanks,

While I am on a roll. I have investigated the User Group sites and see no
method of "subscribing" (or whatever term MS uses) so I would be notified of
new posts to the site - not just replies to my posts. It would seem to be
beneficial to monitor all posts, in some specific software areas, at least,
in order to both learn and be able to share my "learnings" with other. I have
sent an inquiry to MS about this, but have received no adequate response as
yet. Can you point me in the right direction?

"Dave Peterson" wrote:

Put the folder back, but move the addins to a different location--or if you'll
never use them, delete them.

SunTaxMan wrote:

Dave Peterson,

I am having same problem with DistMon and AutoExecNew. I found this string
and followed instructions. What I found was an XLStart folder, but not an
XLStart file. I moved XLStart Folder out of Excel on to Desktop and then
Excel (part of MS Office 2003) would not start.

Can you offer, or any other users, offer some assistance?

I have recently UNinstalled Adobe Acrobat 5.0, after installing MS Office
2003 (I had been using MS OFfice 2000). I did NOT seek any residual Acrobat
files and manually delete them. Is this something I should do? Could this be
part of the problem?

"Dave Peterson" wrote:

Depending on your upgrade path through excel, you could have multiple XLStart
folders.

I'm still betting my money that you have that addin in one of those XLStart
folders.

Close excel
windows start button|search/find
look for pdf*.xla (just in case the name isn't always the same)

If (when!) you find it, move it somewhere else and see what happens when you
start excel the next time.



Sammie wrote:

OK, just to check: I go tools, add-ins, and nothing is checked.
Nothing is in my XLstart folder.
Thanks for any more new ideas.
Sammie

"Frank Kabel" wrote:

Hi
if you have disabled all your addins (and you may double-check this)
also check if you have any files in your XLStart folder

--
Regards
Frank Kabel
Frankfurt, Germany


Sammie wrote:
Nope - this is the kb article I already tried with no joy. I need a
new suggestion. What is autoexecnew and distmon? Is there a visual
basic hidden module? I have disabled all my add-ins. This problem
isn't a show-stopper, but it's been going on for months and it's very
annoying. I will appreciate new ideas. Thanks. Sammie

"Dave Peterson" wrote:

maybe:

http://support.microsoft.com/default...;EN-US;q307410
OFF: "Compile Error in Hidden Module" Error Message When You Start
Word or Excel

It points at PDFMaker.xla as being the culprit.

Sammie wrote:

Every time I open Excel 2003, I get the error: "compile error in
hidden module: AutoExecNew" and on closing, I get the error:
"compile error in hidden module: DistMon". I have read your
knowledge base article on the subject and also searched newsgroups.
Recommended solutions all point to pdfmaker.xla. I have already
deleted all the pdfmaker files but I still get the errors. What
next? Thanks. Sammie

--

Dave Peterson



--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compile error in hidden module: ThisWorkbook Lloyd Excel Discussion (Misc queries) 1 May 27th 05 11:39 PM
Compile error in hidden module: ThisWorkbook Peo Sjoblom Excel Discussion (Misc queries) 0 May 27th 05 09:50 PM
How do I get rid of "Compile error in hidden module" error message David Excel Discussion (Misc queries) 4 January 21st 05 11:39 PM
Excel startup-compile error in hidden module: ApplicationEventHan. [email protected] Excel Discussion (Misc queries) 0 January 8th 05 11:47 PM
Excel startup-compile error in hidden module: ApplicationEventHan. [email protected] Excel Discussion (Misc queries) 0 January 8th 05 11:39 PM


All times are GMT +1. The time now is 01:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"