Run time error '5': while using global variables
Run time error '5': while using global variables i declared the global variable in the Module1 and when i was trying to use it in another module it is showing the runtime error '5':invalid procedure call or argument. i was unable to find the problem please provied the solution for this problem Declaring global variable: Function getFilePath() As String getFilePath = FilePath Set FilePath = "C:quadysterR3AgreementDetails" End Function Implementing of globalvariable: Private Sub SendAgreement_Click() If (Not IsNull(Me.RequestFrom) And Not IsNull(Me.RequestReference)) Then Call AttachR3ServiceAgreement(Module1.FilePath, tripObjectFormation, "Agreement") Me.AgreementDate = Now() Else MsgBox "Please provide 'RequestFrom' and 'RequestReference' to proceed." & vbNewLine & vbNewLine & _ "Press Ok to continue.", vbOKOnly, "Alert!!!" End If End Sub this is the calling function Public F...