XL98 Err Msg: "Name Conflicts with Existing Module"

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In the Visual Basic Editor in Microsoft Excel 98 Macintosh Edition, when you attempt to create a reference from one project to another project, you may receive the following error message:

Name conflicts with existing module, project, or object library

CAUSE

This behavior occurs when both projects have the same name.

RESOLUTION

To resolve this problem, rename the projects that have the same name. To do this, use one of the following methods.

Method 1

1. In the Project window in the Visual Basic Editor, look at the projects that are listed. You should see entries similar to the following

   <VBAProject> (Workbook1)
   <VBAProject> (Workbook2)
   <VBAProject> (Workbook3)

   where <VBAProject> is the name of the project.



2. Click the entry for the project that you want to rename.



3. On the Tools menu, click <VBAProject> Properties
   
   where <VBAProject> is the name of the project.



4. Click the General tab.



5. In the Project Name box, type a new, unique project name.
   
   NOTE: Do not use a project name that you use in any other workbook.



6. Click OK.



7. On the File menu, click Save <bookname>, where <bookname> is the name of the workbook you modified.



8. Repeat steps 1 through 7 for all open workbooks that contain Visual Basic modules, class modules, or Userforms.

Method 2

1. In the Project window in the Visual Basic Editor, look at the projects that are listed. You should see entries similar to the following

   <VBAProject> (Workbook1)
   <VBAProject> (Workbook2)
   <VBAProject> (Workbook3)

   where <VBAProject> is the name of the project.



2. Click the entry for the project that you want to rename.



3. In the Properties window, in the box to the right of "(Name)," type a new, unique project name and press RETURN.
   
   NOTE: Do not use a project name that you used in any other workbook.



4. On the File menu, click Save <bookname>, where <bookname> is the name of the workbook you modified.



5. Repeat steps 1 through 4 for all open workbooks that contain Visual Basic modules, class modules, or UserForms.

MORE INFORMATION

By default, when you create a new workbook in Microsoft Excel 98 Macintosh Edition, the project name for the new workbook is VBAProject. This naming convention may cause a problem if you attempt to create a reference from one project to another when you use the following steps:

1. On the Tools menu, click References.



2. In the list of Available References, click to select the check box for a project in another workbook.



3. Click OK.

REFERENCES

For more information about changing project names in Microsoft Excel 98 Macintosh Edition, click Microsoft Visual Basic Help on the Help menu, click the Index button in Visual Basic for Applications Help, type the following text

project properties dialog box

Additional query words: XL98 vbe

Keywords : kberrmsg kbprg kbdta xlui xlvbainfo
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb