If you want to access VBA Macro from another Excel file Code is as follows:
Option Explicit
Sub accessotherMacro()
Dim pathname As String
Application.ScreenUpdating = False
Dim wb As Workbook
On Error Resume Next
pathname = "C:\Users\abc\Desktop\mybook1.xls"
MsgBox Dir(pathname)
On Error Resume Next
If Not Dir(pathname) = vbNullString Then
Set wb = Workbooks.Open(pathname)
Application.Run (wb.Name & "!test")
ElseIf Dir(pathname) = vbNullString Then
MsgBox "File doesnot Exist"
End If
Application.ScreenUpdating = True
End Sub
