USING EXCEL APPLICATION.RUN IN OUTLOOK

[jbennett]

Well, I'm guessing that based on this ...

Run-time error '1004': Cannot run the macro 'Forward_CC_Response_Auto'. The macro may not be available in this workbook or all macros may be disabled."

and your macro, that all you have is an instance of Excel with no workbook containing your macro

Correct. This macro is only intended for Outlook and the only reason I'm brining in Excel objects is to get access to Application.Run (for some reason the Outlook Application object lacks that method).

I'd start with appExcelRun.Open (...) before trying to run the macro

OK, I tried appExcelRun.Open but .Open does not appear to be a valid method. At least it did not appear in the dropdown list. How would I use it?