Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error when running a vba script.
I have created a macro to combine multiple files which works on my PC using
excel 2000. However, when others run the macro, they get the follwoing error : Comipile error in hidden module : Module 3 It makes no difference on the version of excel they are using , be it 2000 or XP. On further investigation, runnimg the procedure from the VB editor the error highlights the "left" of the first left function used and gives the error : Compile error : can't find project or library From the fact that the errors occurs on a variery of versions of excel including 2000, I have concluded that the remedy lies in the installation of the excel package ot the add ins installed. I have compared mine and another, (who gets the error) but can find very little different. Does any one have any ideas where to look to reslove the problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error when running a vba script.
on a problematic machine, after the error, hit reset, then go into
tools=references and see if you see any references Marked as MISSING. If so this is the cause of your problem. I suspect you are not using this reference in your code, so go back to your machine and remove it - or if you are using it, you need to install the referenced file on the users machine (or if it should already be there, find it using the browse button in the reference dialog). Note that references are specific to individual workbooks, so when you do this make sure your workbook is the activeproject (in the project explorer at least one of the items (sheet, module, etc) is selected. The references dialog is specific to the active project. -- Regards, Tom Ogilvy "AB Robbins" <AB wrote in message ... I have created a macro to combine multiple files which works on my PC using excel 2000. However, when others run the macro, they get the follwoing error : Comipile error in hidden module : Module 3 It makes no difference on the version of excel they are using , be it 2000 or XP. On further investigation, runnimg the procedure from the VB editor the error highlights the "left" of the first left function used and gives the error : Compile error : can't find project or library From the fact that the errors occurs on a variery of versions of excel including 2000, I have concluded that the remedy lies in the installation of the excel package ot the add ins installed. I have compared mine and another, (who gets the error) but can find very little different. Does any one have any ideas where to look to reslove the problem? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error when running a vba script.
Thanks for the suggestion. I have done as you suggested, and double checked
it, and was unable to find any missing references. In addition I have checked the references that are ticked and they are the same on both machines Any more suggetsions ? "Tom Ogilvy" wrote: on a problematic machine, after the error, hit reset, then go into tools=references and see if you see any references Marked as MISSING. If so this is the cause of your problem. I suspect you are not using this reference in your code, so go back to your machine and remove it - or if you are using it, you need to install the referenced file on the users machine (or if it should already be there, find it using the browse button in the reference dialog). Note that references are specific to individual workbooks, so when you do this make sure your workbook is the activeproject (in the project explorer at least one of the items (sheet, module, etc) is selected. The references dialog is specific to the active project. -- Regards, Tom Ogilvy "AB Robbins" <AB wrote in message ... I have created a macro to combine multiple files which works on my PC using excel 2000. However, when others run the macro, they get the follwoing error : Comipile error in hidden module : Module 3 It makes no difference on the version of excel they are using , be it 2000 or XP. On further investigation, runnimg the procedure from the VB editor the error highlights the "left" of the first left function used and gives the error : Compile error : can't find project or library From the fact that the errors occurs on a variery of versions of excel including 2000, I have concluded that the remedy lies in the installation of the excel package ot the add ins installed. I have compared mine and another, (who gets the error) but can find very little different. Does any one have any ideas where to look to reslove the problem? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error when running a vba script.
I suspect the workbook with the problem is not the active PROJECT (active
project, not active workbook in Excel itself - these are not necessarily the same) when you go into tools references. As I said, tools=references refers to the active Project and references are set at the workbook/project level. If you get the error Compile error : can't find project or library a missing reference is about the only thing that will cause that error. -- Regards, Tom Ogilvy "AB Robbins" wrote in message ... Thanks for the suggestion. I have done as you suggested, and double checked it, and was unable to find any missing references. In addition I have checked the references that are ticked and they are the same on both machines Any more suggetsions ? "Tom Ogilvy" wrote: on a problematic machine, after the error, hit reset, then go into tools=references and see if you see any references Marked as MISSING. If so this is the cause of your problem. I suspect you are not using this reference in your code, so go back to your machine and remove it - or if you are using it, you need to install the referenced file on the users machine (or if it should already be there, find it using the browse button in the reference dialog). Note that references are specific to individual workbooks, so when you do this make sure your workbook is the activeproject (in the project explorer at least one of the items (sheet, module, etc) is selected. The references dialog is specific to the active project. -- Regards, Tom Ogilvy "AB Robbins" <AB wrote in message ... I have created a macro to combine multiple files which works on my PC using excel 2000. However, when others run the macro, they get the follwoing error : Comipile error in hidden module : Module 3 It makes no difference on the version of excel they are using , be it 2000 or XP. On further investigation, runnimg the procedure from the VB editor the error highlights the "left" of the first left function used and gives the error : Compile error : can't find project or library From the fact that the errors occurs on a variery of versions of excel including 2000, I have concluded that the remedy lies in the installation of the excel package ot the add ins installed. I have compared mine and another, (who gets the error) but can find very little different. Does any one have any ideas where to look to reslove the problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
question about some excel restriction script running on ... | Excel Discussion (Misc queries) | |||
question about some excel restriction script running on ... | Excel Discussion (Misc queries) | |||
Running a script while editing a cell | Excel Discussion (Misc queries) | |||
Help in running this script lower than Excel 2000 | Excel Programming | |||
Running a VB Script | Excel Programming |