C:\Documents and Settings\<user>\Local Settings\Temporary
Internet Files\...
Is there a way to get it to automatically save to Excel's
default location (under Options>General)?
Thanks.....Kyle
When you open the attachment, Outlook has to have some scratch area to make the
attachment an excel file. It looks like you know your location.
You could use some kind of macro that looked something like:
ActiveWorkbook.SaveAs _
Filename:=Application.DefaultFilePath & "\" & ActiveWorkbook.Name
But I find it easier to just add that location to the left hand side of the
SaveAs dialog.
Point to your folder (inside the file|SaveAs dialog),
then Tools|Add to "My Places"
Then you'll have a quick shortcut to that folder. (And you can add other
folders there, too.)
--
Dave Peterson
ec3...@msn.com