Bobendren

I need to save and close a specific Excel file from an Outlook VBA macro.
The excel file is not opened through Outlook VBA, but is already open.
I know the name of the file.

How would I do this?

ajetrumpet

you will need the excel reference library in the vba editor first of all. then, check out the workbook object and application object in excel with the intellisense dropdown in vba. you probably need to use the CLOSE action of the workbooks collection (of the application object). you may need to supply the full directory of the file name you want to close.

if that doesn't work, it is possible that you may need to have opened the workbook in vba in order to close it, but i seriously doubt that is the case.