Saving email attachments

[Dixon7]

Customer has a spreadsheet attachment that he opens from his email and
modifies. He said he continually saved the document. I don't see how that
is possible in 2007 because it will not allow you to just save a read-only
file. If he did save it, as "Stewart 1", where is it? He is nokw up to
Stewart 3, but the changes he made are on Stewart 1 or Stewart 2. Any ideas
would be appreciated.

 

[JLatham]

Have him open it up and then use File --> Save As and look at the path
provided, that'll tell you where it went. Might be in temporary internet
files area, or somewhere else.

 

[Dixon7]

It just goes to the My Documents folder -- but it is not there. I have done
a complete search, both from a date range, a .xls and .xlsx and by name.

 

[JLatham]

Can you open it up and add a little VBA code module to it? (It'll need to be
saved as .xlsm after adding the code unless you decide not to keep the code).

Sub WhereDoILive()
MsgBox "I am stored in: " & vbCrLf & ThisWorkbook.FullName
End Sub

Just open the workbppk, press [Alt]+[F11] to open the VB Editor. In it,
choose Insert --> Module and copy the code above and paste it into the module
presented to you. Then simply run the macro to see the full path to the
workbook.

 

[Dixon7]

Sorry but you lost me. We cannot find the file, so I don't see how we can
open it and add code to it.

Can you open it up and add a little VBA code module to it? (It'll need to be
saved as .xlsm after adding the code unless you decide not to keep the code).

Sub WhereDoILive()
MsgBox "I am stored in: " & vbCrLf & ThisWorkbook.FullName
End Sub

Just open the workbppk, press [Alt]+[F11] to open the VB Editor. In it,
choose Insert --> Module and copy the code above and paste it into the module
presented to you. Then simply run the macro to see the full path to the
workbook.

It just goes to the My Documents folder -- but it is not there. I have done
a complete search, both from a date range, a .xls and .xlsx and by name.

 

[jaf]

Hi,
If you open a file attachment and then save it, it is saved to a temporary internet folder.
Search there.

John

 

[Dixon7]

You cannot do that in Excel 2007 - it says it is a read-only file and you
must do a save as, which he said he did not do.

 

[jaf]

In that case the file does not exist.
You can stop looking for it.

John

 

[JLatham]

I go along with jaf - he's not really ever saved it. If it was read-only,
Excel is going to ignore his changes no matter what. Needs to Save As and
then work with the renamed copy.