ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Compile error in hidden module (https://www.excelbanter.com/excel-discussion-misc-queries/35926-compile-error-hidden-module.html)

arjay

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


Dave Peterson

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

SunTaxMan

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

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

SunTaxMan

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

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


All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com