Thanks - After more digging, I realized I could do it via a module:
Sub RunExcelMacro()
Dim xl As Object
'Step 1: Start Excel, then open the target workbook.
Set xl = CreateObject("Excel.Application")
xl.Workbooks.Open ("C:\Documents and Settings\nel58556\My Documents\Net Improvement Report\CM NEW RPS - PM AT RISK.xlsm")
'Step 2: Make Excel visible
xl.Visible = False
'Step 3: Run the target macro
xl.Run "DeleteWorksheets"
xl.Run "DeleteFiles"
'Step 4: Close and save the workbook, then close Excel
xl.ActiveWorkbook.Close (True)
xl.Quit
'Step 5: Memory Clean up.
Set xl = Nothing
End Sub
Appreciate the feedback though!
Have a good day.
Sara