When Excel opens a file, it creates a temporary file in the same directory. This file disappears as soon as the Excel workbook is closed again. But what if I want these temporary files to be created in a chosen location, instead of the same directory as where my file resides?
Bookmarks