Could a macro insert a column that contains the filename of the document in every cell?
I have invoices sent to me in the form of Word tables, each with the filename as the date of the invoice. The table itself does not contain the date, so I am wondering if there is a way to insert a column (preferably on the left) where the cells contain the filename (the date) in every row. Eventually I combine each file to one spreadsheet, so having the date in the first column would be fantastic.
I receive 7 invoices at once each week, so any "today" functions aren't really useful.
Any thoughts?
|