Open workbooks with different names

J

Jako

Could someone please help me with the following:

I need to open .xls files that have different names each time and the
i need to make the name of the opened .xls file static so i can the
save it again in a set folder on c:

Eg. the file is emailed as 0404 3785.xls

I need to load/or activate the file in order to then extract the dat
from it and then set the filename as a Static variable.

I then need a routine to save the .xls file in folder DSP on C:

Any help most appreciated
 
R

Ron de Bruin

Eg. the file is emailed as 0404 3785.xls

Am I correct that you want to open the file in the mail you receive
without copy it in a folder on your harddisk first
 
J

Jako

Either or !

I guess it would be easier to detach to a folder called EmailIn
on the C:

Thanks for taking the time
 
Top