Excel issue - Link a cell to the number of documents in a file

I am trying to get an excel spreadsheet to update when a document is inserted into a file.

For example I have a folder called day diary. Every few days I will insert a word document or PDF document into this folder. I would like for the excel spreadsheet to acknowledge that a document has been put in the file.

Is this possible?

VBA welcome, however I have no experience in it. (Willing to lea a bit)

Thanks for your time!

Recent Questions...