Calling a macro from a excel sheet

[canada18]

I am trying to call a macro written in excel and calling from VBA code. Macro is in worksshet within a workbook.
Error message is : Object variable or with block variable not set
Any idea what it is complaining about?

[ADezii]

I am trying to call a macro written in excel and calling from VBA code. Macro is in worksshet within a workbook.
Error message is : Object variable or with block variable not set
Any idea what it is complaining about?

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook

Set xlApp = New Excel.Application
xlApp.Visible = True
Set xlBook = xlApp.Workbooks.Open("C:\Test\Test.xls")

'Run the macro
xlApp.Run "Macro1"

'Your choice
'xlApp.Quit