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.