importing file names

  • Thread starter Thread starter Sheila
  • Start date Start date
S

Sheila

I need to know how to set up a workbook so that I can list each file
name in a specific folder in cell a1:A?, also I need to put the oinfo
from say Cell B1 in those workbooks into B1 in the sheet I am using to
summarise, same also for info in cell C1.

I dont mind if this is completed as the workbook opens or if I have to
click a button to make it happen, so long as it happens. The only
files in the folder (say c:\Jobs\*.*) are Excel workbooks.

Hope someone can help.

Sheila
TIA
 
That wasnt really clear was it, sorry, all the workbooks in the folder
only have one sheet in them, I should of said that, sorry. Would also
be good too if the file name that is entered, DIDNT have the .xls at
the end of it.

thanks again
sheila
 
Back
Top