troubleshooting Question

Error calling Class Module

Avatar of Tracy
TracyFlag for United States of America asked on
Microsoft ExcelMicrosoft OfficeMicrosoft Applications
14 Comments2 Solutions589 ViewsLast Modified:
Hi guys,

I have a class module called cls_Cfg and this is a function in the class module:

Private Function EncryptFile(ByVal InFile As String, ByVal OutFile As String, _
 ByVal Overwrite As Boolean, ByVal Key As String) As Boolean

I want to call this routine from a regular module, but when I try the below code I get a compile error saying method or data members not found.  I'm not sure what the syntax is, I don't use class modules that often.

Thanks,
Tracy
Sub testCall()

    Dim clsX As cls_Cfg
    
    Set clsX = New cls_Cfg
    clsX.EncryptFile("H:\tracy\cfg\temp.txt", "H:\tracy\cfg\temp2.txt", True, "test") = True
    Set clsX = Nothing

End Sub

Open in new window

ASKER CERTIFIED SOLUTION
rspahitz

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros