Our CEO is adamant about always having the same default path for any "save as" dialog box and wants this to be a network share that is a mapped drive for him.
I've been able to get this to work with everything except when he gets an email in Outlook that is a compressed Excel sheet. No matter what, it temporarily decompresses the file to
C:\users\myusername\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\R4M5I5UR\filename.xls
This is in Windows 7.
He's expecting to be able to just double click the attachment, which opens up the file with Windows Explorer in the above path, then double click the Excel sheet, and now from within excel, click save as, and have it default to his network drive (this is setup as the default save path for Excel). Instead it goes to try to save the file to a new folder for the zip file under:
I cannot find in the registry on any forums where to control this behavior, or whether doing so will affect the temporary save location for Windows Explorer in general.
I had another idea of trying to use different software, like WinRAR, that would let me change this location, which it does seem to work, however, it also creates its own temp folder in this path that it decompresses to, like Rar$DI00.717
Which is close, but no cigar. I'm not opposed at all to using or purchasing any third party software, just need it save the excel sheet at the root level of the network drive, without adding any cryptic temp folder or renaming the file.
All in all, if anybody has an idea how to accomplish the above objective, where no matter what, a zipped Excel sheet opened as an attachment in Outlook will actually use or obey the default save location setup in Excel, rather than some other temp location, please let me know.