Florian has attended:
Excel VBA Advanced course
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
RE: Referencing a workbook containing VBA
Hi Florian
Thanks for your question
I'm not sure I understand what you are trying to do. I don't understand what you mean by "attach(ing) a workbook to the code".
Could you clarify this for me?
Thanks
Stephen
RE: Referencing a workbook containing VBA
Hello,
What I was trying to do is to reference another workbook within the VBA editor. I think that it needs to be done in the same way as referencing "Microsoft Office 10.0 Object Library".
Please let me know if that helps.
Best Regards,
Florian
