Office XP - Saving Excel file opened from Outlook

  • Thread starter Thread starter Kyle
  • Start date Start date
K

Kyle

When opening an Excel file from Outlook XP, and then
doing as "Save As...", Excel ignores the default location
and attempts to save it to a location something like this:

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
 
I'm not sure there is a way.

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.)
 
Back
Top