Get workbook name that called macro

[mahmed1]

Hi guys

I have a macro in access that is called from
Excel

in the access macro- How can i get the workbook name that called the macro?

 

[Legacy 456155]

Here are a few examples.

Public Sub AccessProcedure1(caller As Object)
    If TypeName(caller) = "Workbook" Then Debug.Print caller.Name, caller.FullName
End Sub

'if you have set a reference to Excel lib from within Access
Public Sub AccessProcedure2(caller As Excel.Workbook)
    If TypeOf caller Is Workbook Then Debug.Print caller.Name, caller.FullName
End Sub

 

[xenou]

Also you could pass in the workbook name as a parameter or an optional parameter if you need backward compatibility.

 

[mahmed1]

Thank you all