Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with reference
I am trying to use some code from Ron de Bruin's Excel pages. I tried to add
a reference to Microsoft Outlook 11.0 Object Library, and am getting "Name conflicts with existing project, module, or object library". I removed every reference I could to see which was the conflict, and now have only: Visual Basic for Applications Microsoft Excel 11.0 Object Library Microsoft Forms 2.0 Object Library I looked for redundant sub names, none ... Anyone know what is my issue pls? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with reference
This often happens when you create a reference to a workbook where the
default name is vbaproject and causes a conflict with the workbook containing the reference which is also named vbaproject. This may not be your situation, but it is the most common situation where I have seen this message. -- Regards, Tom Ogilvy "William Benson" wrote in message ... I am trying to use some code from Ron de Bruin's Excel pages. I tried to add a reference to Microsoft Outlook 11.0 Object Library, and am getting "Name conflicts with existing project, module, or object library". I removed every reference I could to see which was the conflict, and now have only: Visual Basic for Applications Microsoft Excel 11.0 Object Library Microsoft Forms 2.0 Object Library I looked for redundant sub names, none ... Anyone know what is my issue pls? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with reference
Nothing open but Personal.Xls Tom ... I am stumped (and oh by the way, shut
out of Ron's nice code samples) "Tom Ogilvy" wrote in message ... This often happens when you create a reference to a workbook where the default name is vbaproject and causes a conflict with the workbook containing the reference which is also named vbaproject. This may not be your situation, but it is the most common situation where I have seen this message. -- Regards, Tom Ogilvy "William Benson" wrote in message ... I am trying to use some code from Ron de Bruin's Excel pages. I tried to add a reference to Microsoft Outlook 11.0 Object Library, and am getting "Name conflicts with existing project, module, or object library". I removed every reference I could to see which was the conflict, and now have only: Visual Basic for Applications Microsoft Excel 11.0 Object Library Microsoft Forms 2.0 Object Library I looked for redundant sub names, none ... Anyone know what is my issue pls? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with reference
I think the module name was a no-no... I had named it "Outlook" and was
trying to make a reference to Object Library for Outlook. I got rid of the module, and I could make the reference. Thanks "William Benson" wrote in message ... Nothing open but Personal.Xls Tom ... I am stumped (and oh by the way, shut out of Ron's nice code samples) "Tom Ogilvy" wrote in message ... This often happens when you create a reference to a workbook where the default name is vbaproject and causes a conflict with the workbook containing the reference which is also named vbaproject. This may not be your situation, but it is the most common situation where I have seen this message. -- Regards, Tom Ogilvy "William Benson" wrote in message ... I am trying to use some code from Ron de Bruin's Excel pages. I tried to add a reference to Microsoft Outlook 11.0 Object Library, and am getting "Name conflicts with existing project, module, or object library". I removed every reference I could to see which was the conflict, and now have only: Visual Basic for Applications Microsoft Excel 11.0 Object Library Microsoft Forms 2.0 Object Library I looked for redundant sub names, none ... Anyone know what is my issue pls? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A reference problem - I THINK? | Excel Discussion (Misc queries) | |||
Reference problem | Excel Discussion (Misc queries) | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Need help with this reference problem | Excel Programming | |||
Another Reference Problem | Excel Programming |