Getting Start - Newbie Question

[da644]

Hi Everyone.

I need to write a small VBA for Outlook and I have found an example that is reasonabily similar to what I need to do. I the example it says the code needs to be placed in a 'class module'. I have created a new macro and placed the code in a 'class module' but I assume I need to call the sub procedure in the 'class module' from the main module, but I don't see how you do this. I tried to just simply place the name of the sub into the main module sub:

Sub test()
Initialize_handler
End Sub

but this just created an error. Can someone point me in the write direction or the direction of a good online guide for VBA beginners.

Thanks

Andrew.

 

[Loomah]

Hi
I'm no genius when it comes to using class modules having had mixed success myself but have a look at this FAQ (faq707-4974) to see if it's any use. It gives the basic structure of what you should need - even if it is based on Excel.

Good Luck!
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244