Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Referencing a workbook containing VBA
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Referencing a workbook containing VBA
Resolved · Low Priority · Version 2003
Reply
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
For upcoming training course dates see: Pricing & availability
RE: Referencing a workbook containing VBA
Hi FlorianThanks 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
|
 |
|
» Forum post: EXCEL |
How do I use validation in cells?
