Referencing a workbook containing VBA

Hello,

I tried to apply what we learned at the beginning of the week and it works.

Before the course, I had few reports using similar pieces of codes. Hence, I decided to store all the codes and some look-up tables in a separate spreadsheet that all my reports would access.

In order to do so, when I try to attach a workbook to the code (in VBA: Tools – References – Browse ) to the VBA, I get the following error message: “Name conflicts with existing module, project or library”. Even though, it does not look like there should be a conflict.

Does any one have any idea on how could this be fixed?

Thanks a lot

Florian