View Single Post
 
Old 01-23-2019, 11:24 AM
blorence blorence is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jan 2019
Posts: 5
blorence is on a distinguished road
Default 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?
Reply With Quote