Hey there,
I am kinda lost. I got a bunch of word documents (appx. 300(!)) and i need to get them into one excel file. I could do it manually, but I am sure, that there is an easier way.
If you look at the word docs, you'll see that they are kind of unprofessional, but I can't change it. I really only need the table from the word file, BUT the I also need the date.
And that's the tricky part, because the date and timestamp can be either taken from the file name itself or from the 'unprofessional' header.
So, is there a chance to get all the lines from the files automatically copied into one excel table and add a field with the file name (original word doc) behind each line?
All files will be saved in one folder.
If anyone have an idea, how i could solve my problem, I would save me hours of manual work. That would we awesome!!
Thanks a lot!!!!
Cheers,
Phil
Bookmarks