VBA script to close Excel file opened in Outlook

**Metrazal** · 07-28-2014, 02:25 PM

Using VB I need to close a workbook that I opened with Outlook. I open the excel file manually by double-clicking on an attachment in outlook and then run a vba script file that copies some of the contents to another excel file that is opened within the script. (The script is executed from my personal workbook.) I may have multiple workbooks open including my personal workbook and the newly created workbook but I only want to close the one manually opened from Excel. Any ideas?

Note: The file opened in outlook has variable filenames.

Thanks,

Met

**Hawkeye16** · 07-29-2014, 04:18 AM

How do you reference the workbook opened from Outlook when copying data from it in your macro?

If you use a name Workbooks("Name").Close
If you use reference Workbooks(1).Close
If you use a variable wkbk.Close

**Metrazal** · 07-29-2014, 09:59 AM

Being able to reference the workbook is my problem. (I will open the inital file through Outlook and it has random filenames.)

My best option at this point is to make sure I have no other Excel files open and close the file via the Workbooks(2).Close option. (My personal workbook resides in slot 1.) I thought about having some sort of selection but I have decided against this as I could just as easily close the window manually. I think I have just overthought this task. In any case, Hawkeye, thank you for your response.

Thanks,
Met