N
neptune
Hi,
I hope that anyone can help me. I have 300 excel files to process, I
don't what to have to open all these files one by one. What I have to
do is the following: I have to modify the excel files in some simple
way, add a column and insert the filename of the corresponding file in
this column for every line items of my excel file.
example :
dir \name_my_excels\ has 2 files, fileA(5 lines) and fileB(10 lines)
To do:
open fileA, add a column, insert the filename in the columnF for the 5
active lines and close the file,
open fileB, add a column, insert the filename in the columnF for the 10
active lines and close the file,
and so on, this for 300 times.
Is there a way that I can do this on one files and batch process my
directory to have it done on all my excel files?
A quick respond an a software, macro or anything like this would same
me time and energy.
Thanks a lot,
Marc
ps. Can anyone cross post this message for me, I'm new to groups
I hope that anyone can help me. I have 300 excel files to process, I
don't what to have to open all these files one by one. What I have to
do is the following: I have to modify the excel files in some simple
way, add a column and insert the filename of the corresponding file in
this column for every line items of my excel file.
example :
dir \name_my_excels\ has 2 files, fileA(5 lines) and fileB(10 lines)
To do:
open fileA, add a column, insert the filename in the columnF for the 5
active lines and close the file,
open fileB, add a column, insert the filename in the columnF for the 10
active lines and close the file,
and so on, this for 300 times.
Is there a way that I can do this on one files and batch process my
directory to have it done on all my excel files?
A quick respond an a software, macro or anything like this would same
me time and energy.
Thanks a lot,
Marc
ps. Can anyone cross post this message for me, I'm new to groups