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

--
Message posted from http://www.ExcelForum.com