Using Classes In Multiple Projects

**JackL** · 09-22-2008, 07:45 AM

Hi

I am trying to replicate the class example on Chip Pearson's site:

http://www.cpearson.com/excel/Classes.aspx

In particular I am interested in having a class that can be accessed by multiple workbooks.

Please can you let me know why this will not compile?

Thanks for your help!

**Andy Pope** · 09-22-2008, 07:54 AM

You need to read the instruction carefully.

Back in the project containing the class, create a procedure that will create and return a new instance of the class:

The GetClass function needs to be in a module not the class.

**JackL** · 09-22-2008, 08:20 AM

thanks Andy

**JackL** · 09-22-2008, 08:39 AM

I have a new problem now that is when I try to initialise the class in a different workbook it will not compile saying user defined type not defined.

Any idea what I have forgotten to do?

Thanks again

**Andy Pope** · 09-22-2008, 08:44 AM

Did you include a reference to the project with the class in it?

**JackL** · 09-22-2008, 08:57 AM

No - please let me know how to reference it.

Thanks

**Andy Pope** · 09-22-2008, 08:58 AM

Tools > References
The project name should be in the list.

**JackL** · 09-22-2008, 09:20 AM

Thanks!!!!!!!!!!!

**JackL** · 09-23-2008, 05:57 AM

I have a new problem. The module that is using the class saved in another workbook has an object that needs to be available to the class. The project will not compile because the class cannot reference the object error: variable not defined.

The object is set as public so I don't know what else to try. Is it even possible?

Thanks for your help
Jack

**Andy Pope** · 09-23-2008, 06:49 AM

What object?

Can you post your files. Both the one holding the class and the one trying to use it.

**JackL** · 09-23-2008, 07:47 AM

Please see attached files. It won't compile due to the 'fund' and 'ccy' objects not being available to the class.

Thanks...

**Andy Pope** · 09-23-2008, 08:08 AM

You need to pass the information to the class. It can not "see" the variables in the other project.

Add to new Set statements to the class.
Make the assignments in your main project.
Amend code in class to handle local references.

project code

Please Login or Register  to view this content.

Class code

Please Login or Register  to view this content.

You should also add objects to allow referencing to local sheets.
Otherwise writing a class with specific sheet references and hoping the active workbook is relevant sort of defeats the point of using a class across projects. You might as well copy the whole class code over.