Referring to variable present in macro from another workbook

[vidyanand]

Hello, I want to get value of variable from macro which is present in another workbook. I tried below code.

errmsg = errmsg & Application.Run("'" & filename & "'!appending_data").errm & vbnextline

Obviously I messed with syntax. I am not into coding. Could you please help me with the same.