Hello,
My friends I have a great need witch I googled after for so many time and find no or 60% answer.
This is:
I have daily workbooks which have the same format and which have diferent name (for example 20042008.xls, 21042008.xls) all stored in the same folder.
What I want is to have all these workbooks imported in a table and (this is what I have'nt find) to insert a new column called "data" in which automatically the name of the woorkbooks to be added.
I will appreciate any references.
Thank you
My friends I have a great need witch I googled after for so many time and find no or 60% answer.
This is:
I have daily workbooks which have the same format and which have diferent name (for example 20042008.xls, 21042008.xls) all stored in the same folder.
What I want is to have all these workbooks imported in a table and (this is what I have'nt find) to insert a new column called "data" in which automatically the name of the woorkbooks to be added.
I will appreciate any references.
Thank you