Using VBA to Copy Meta Data

EssBase 19c

I have successfully used this logic in VBA for Excel to copy metadata from one worksheet to another and then refresh EssBase for all worksheets:

Sub Example_HypCopyMetaData()

lngReturn = HypCopyMetaData("sheet1", "sheet4")

lngReturn = HypMenuVRefreshAll()

End Sub

I need to do this from workbook to workbook, meaning instead of

lngReturn = HypCopyMetaData("sheet1", "sheet4")

i need something more like this"

lngReturn = HypCopyMetaData("book1.sheet1", "book2.sheet4")

i have been unable to get this to work. Any suggestions? thank you