VBScript to VBA question.

[oppcos]

Hi,
I wrote a class for use with Outlook Forms that does a variety of behind the scene things and I've been asked to provide the class for an Excel document. Unfortunately, appartently Outlook uses VBScript and Excel uses VBA and from what I understand there is no such thing as a 'Class' in VBA.

Does anyone know of any alternatives or have suggestions for converting a VBScript Class into a nice oop package for VBA macros to take advantage of?

Thanks

 

[PHV]

In VBA you may create a Class module.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[oppcos]

Sorry to sound so ignorant but can you explain that a bit more or give a link? I haven't had success just doing something like this:
Class MyClass
Private Property

Public Function(param)
...'
End Function
End Class

 

[PHV]

menu Insert -> Class module

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886