Open workbooks with different names

  • Thread starter Thread starter Jako
  • Start date Start date
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
 
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
 
Either or !

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

Thanks for taking the time
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA insert column with two workbooks open 1
Error Opening Workbook 3
Open and Save Files in Directory 1
loop thru folder looking for files with date code in name 7
Get sheets name without file open 7
Open files from folder by matching name 1
Userform Save data To Worksheet & File 1
hope someone can help with excel save with 2003 and 2007 installed on my computer 9

Back
Top