Open workbooks with different names
 

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

Open workbooks with different names
 

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jako " wrote in message ...
Could someone please help me with the following:

I need to open .xls files that have different names each time and then
i need to make the name of the opened .xls file static so i can then
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 data
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/

Open workbooks with different names
 

Either or !

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

Thanks for taking the time

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

Open workbooks with different names
 

look at this webpage
http://www.dicks-clicks.com/excel/ol...ve_Attachments


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jako " wrote in message ...
Either or !

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

Thanks for taking the time.


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