|
Compile error in Excel 2002
I have Excel 2002 installed on a Windows 7 machine. While this version of
Excel was installed on Win XP, it worked fine. However, since I installed it on Win 7, every time I open or close an Excel file, I'm getting an MS Visual Basic compile error in hidden module. On opening a file, it is AutoExecNew module, on exit - DistMon. I followed advice in the MS KB Article ID: 307410 and removed both pdfmaker.dot and pdfmaker.xla. But it did not help. The error message pops up again... Is there any other solution to this problem? -- Ilya Zeldes Fort Myers, Florida |
Compile error in Excel 2002
Most likely you need to repair Office. You will find instructions at
http://www.add-ins.com/how_to_repair_office.htm that will give you the steps to follow. Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Ilya Zeldes" wrote in message ... I have Excel 2002 installed on a Windows 7 machine. While this version of Excel was installed on Win XP, it worked fine. However, since I installed it on Win 7, every time I open or close an Excel file, I'm getting an MS Visual Basic compile error in hidden module. On opening a file, it is AutoExecNew module, on exit - DistMon. I followed advice in the MS KB Article ID: 307410 and removed both pdfmaker.dot and pdfmaker.xla. But it did not help. The error message pops up again... Is there any other solution to this problem? -- Ilya Zeldes Fort Myers, Florida |
Compile error in Excel 2002
Don,
thanks for your suggestion. I checked my add-ins. There is Analysis ToolPack, Analysis ToolPack-VBA, Conditional Sum Wizard, etc, but there is no xl... Ilya "Don Guillett" wrote in message ... Check your addin toolsaddin Leave xl and come back -- Don Guillett Microsoft MVP Excel SalesAid Software "Ilya Zeldes" wrote in message ... I have Excel 2002 installed on a Windows 7 machine. While this version of Excel was installed on Win XP, it worked fine. However, since I installed it on Win 7, every time I open or close an Excel file, I'm getting an MS Visual Basic compile error in hidden module. On opening a file, it is AutoExecNew module, on exit - DistMon. I followed advice in the MS KB Article ID: 307410 and removed both pdfmaker.dot and pdfmaker.xla. But it did not help. The error message pops up again... Is there any other solution to this problem? -- Ilya Zeldes Fort Myers, Florida |
Compile error in Excel 2002
Robert,
thanks for a link. I checked out this article. Although I did not mention it in my original post, I uninstalled and reinstalled Office XP Pro 2002 without any improvement. Nevertheless, I followed the recommendations for Excel 2002 users and installed SP 1, 2, and 3. No luck... I should add, that the error appears only if I start Excel from an .xls file. If I open Excel first and then open any .xls file from the File menu, this file opens without a glitch... Ilya "Robert Flanagan" wrote in message ... Most likely you need to repair Office. You will find instructions at http://www.add-ins.com/how_to_repair_office.htm that will give you the steps to follow. Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Ilya Zeldes" wrote in message ... I have Excel 2002 installed on a Windows 7 machine. While this version of Excel was installed on Win XP, it worked fine. However, since I installed it on Win 7, every time I open or close an Excel file, I'm getting an MS Visual Basic compile error in hidden module. On opening a file, it is AutoExecNew module, on exit - DistMon. I followed advice in the MS KB Article ID: 307410 and removed both pdfmaker.dot and pdfmaker.xla. But it did not help. The error message pops up again... Is there any other solution to this problem? -- Ilya Zeldes Fort Myers, Florida |
Compile error in Excel 2002
Ilya, try unchecking all the add-ins in Tools, Add-ins and see if that
solves. If it does, add back the ones you need one by one, testing in between adding. What you describe is an error in the installation of Office. The only cure may be to go to Excel 2003 (via ebay purchase) or 2007 if you need the add-in that is causing the error. Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Ilya Zeldes" wrote in message ... Don, thanks for your suggestion. I checked my add-ins. There is Analysis ToolPack, Analysis ToolPack-VBA, Conditional Sum Wizard, etc, but there is no xl... Ilya "Don Guillett" wrote in message ... Check your addin toolsaddin Leave xl and come back -- Don Guillett Microsoft MVP Excel SalesAid Software "Ilya Zeldes" wrote in message ... I have Excel 2002 installed on a Windows 7 machine. While this version of Excel was installed on Win XP, it worked fine. However, since I installed it on Win 7, every time I open or close an Excel file, I'm getting an MS Visual Basic compile error in hidden module. On opening a file, it is AutoExecNew module, on exit - DistMon. I followed advice in the MS KB Article ID: 307410 and removed both pdfmaker.dot and pdfmaker.xla. But it did not help. The error message pops up again... Is there any other solution to this problem? -- Ilya Zeldes Fort Myers, Florida |
Compile error in Excel 2002
Robert,
thanks for the suggestions. All the add-ins are unchecked. Apparently I have none. As of Excel 2007, this could be a culprit. You see, when I switched to Win 7, I installed MS Office Home and Student 2007. For a while, I used Excel and Word, but did not like it. So, I uninstalled MSOH&S 2007 and installed my old and trusted Office XP Pro 2002. Now everything works fine and the way I like it with this compile error exception... Do you think that uninstalled Office 2007 left some residue somewhere in the registry or elsewhere which causes this error? Ilya "Robert Flanagan" wrote in message ... Ilya, try unchecking all the add-ins in Tools, Add-ins and see if that solves. If it does, add back the ones you need one by one, testing in between adding. What you describe is an error in the installation of Office. The only cure may be to go to Excel 2003 (via ebay purchase) or 2007 if you need the add-in that is causing the error. Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Ilya Zeldes" wrote in message ... Don, thanks for your suggestion. I checked my add-ins. There is Analysis ToolPack, Analysis ToolPack-VBA, Conditional Sum Wizard, etc, but there is no xl... Ilya "Don Guillett" wrote in message ... Check your addin toolsaddin Leave xl and come back -- Don Guillett Microsoft MVP Excel SalesAid Software "Ilya Zeldes" wrote in message ... I have Excel 2002 installed on a Windows 7 machine. While this version of Excel was installed on Win XP, it worked fine. However, since I installed it on Win 7, every time I open or close an Excel file, I'm getting an MS Visual Basic compile error in hidden module. On opening a file, it is AutoExecNew module, on exit - DistMon. I followed advice in the MS KB Article ID: 307410 and removed both pdfmaker.dot and pdfmaker.xla. But it did not help. The error message pops up again... Is there any other solution to this problem? -- Ilya Zeldes Fort Myers, Florida |
Compile error in Excel 2002
May help...
Right-click a sheet tab and select "View Code". When the VB editor opens Tools References In the References dialogue box, uncheck any object that is marked "Missing". George Gee "Ilya Zeldes" wrote in message ... Robert, thanks for the suggestions. All the add-ins are unchecked. Apparently I have none. As of Excel 2007, this could be a culprit. You see, when I switched to Win 7, I installed MS Office Home and Student 2007. For a while, I used Excel and Word, but did not like it. So, I uninstalled MSOH&S 2007 and installed my old and trusted Office XP Pro 2002. Now everything works fine and the way I like it with this compile error exception... Do you think that uninstalled Office 2007 left some residue somewhere in the registry or elsewhere which causes this error? Ilya "Robert Flanagan" wrote in message ... Ilya, try unchecking all the add-ins in Tools, Add-ins and see if that solves. If it does, add back the ones you need one by one, testing in between adding. What you describe is an error in the installation of Office. The only cure may be to go to Excel 2003 (via ebay purchase) or 2007 if you need the add-in that is causing the error. Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Ilya Zeldes" wrote in message ... Don, thanks for your suggestion. I checked my add-ins. There is Analysis ToolPack, Analysis ToolPack-VBA, Conditional Sum Wizard, etc, but there is no xl... Ilya "Don Guillett" wrote in message ... Check your addin toolsaddin Leave xl and come back -- Don Guillett Microsoft MVP Excel SalesAid Software "Ilya Zeldes" wrote in message ... I have Excel 2002 installed on a Windows 7 machine. While this version of Excel was installed on Win XP, it worked fine. However, since I installed it on Win 7, every time I open or close an Excel file, I'm getting an MS Visual Basic compile error in hidden module. On opening a file, it is AutoExecNew module, on exit - DistMon. I followed advice in the MS KB Article ID: 307410 and removed both pdfmaker.dot and pdfmaker.xla. But it did not help. The error message pops up again... Is there any other solution to this problem? -- Ilya Zeldes Fort Myers, Florida |
Compile error in Excel 2002
Thanks, George, tried this. There's no missing object... As a matter of
fact, the window in the right pane "Sheet 1 Code" is empty. Ilya "George Gee" wrote in message ... May help... Right-click a sheet tab and select "View Code". When the VB editor opens Tools References In the References dialogue box, uncheck any object that is marked "Missing". George Gee "Ilya Zeldes" wrote in message ... Robert, thanks for the suggestions. All the add-ins are unchecked. Apparently I have none. As of Excel 2007, this could be a culprit. You see, when I switched to Win 7, I installed MS Office Home and Student 2007. For a while, I used Excel and Word, but did not like it. So, I uninstalled MSOH&S 2007 and installed my old and trusted Office XP Pro 2002. Now everything works fine and the way I like it with this compile error exception... Do you think that uninstalled Office 2007 left some residue somewhere in the registry or elsewhere which causes this error? Ilya "Robert Flanagan" wrote in message ... Ilya, try unchecking all the add-ins in Tools, Add-ins and see if that solves. If it does, add back the ones you need one by one, testing in between adding. What you describe is an error in the installation of Office. The only cure may be to go to Excel 2003 (via ebay purchase) or 2007 if you need the add-in that is causing the error. Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Ilya Zeldes" wrote in message ... Don, thanks for your suggestion. I checked my add-ins. There is Analysis ToolPack, Analysis ToolPack-VBA, Conditional Sum Wizard, etc, but there is no xl... Ilya "Don Guillett" wrote in message ... Check your addin toolsaddin Leave xl and come back -- Don Guillett Microsoft MVP Excel SalesAid Software "Ilya Zeldes" wrote in message ... I have Excel 2002 installed on a Windows 7 machine. While this version of Excel was installed on Win XP, it worked fine. However, since I installed it on Win 7, every time I open or close an Excel file, I'm getting an MS Visual Basic compile error in hidden module. On opening a file, it is AutoExecNew module, on exit - DistMon. I followed advice in the MS KB Article ID: 307410 and removed both pdfmaker.dot and pdfmaker.xla. But it did not help. The error message pops up again... Is there any other solution to this problem? -- Ilya Zeldes Fort Myers, Florida |
| All times are GMT +1. The time now is 10:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com