VBA Upgrade; Add folder browse & date/time & filename stamp

[Webbers]

Okay I have a functional VBA script, however I do have a need for it to have additional features, which is based on who my users are now for this file. As a result, this functionality is rather important.

1. I would like to be able to change the hard coded folder path within this VBA to allow the user to browse for a folder.
2. I would like to be able to add the date/time stamp to Column Q, and the Filename to column R. These would be contigent on the fact that there is data in column A. And that data was added from the merge done by this macro.

Please Login or Register  to view this content.

[pjwhitfield]

For part 1 replace the line starting

Please Login or Register  to view this content.

with the following:

Please Login or Register  to view this content.

[Webbers]

pjwhitfield-----

I edited the Code per your instructions. A prompt appear allowing me to browse for a folder, which I did (wonderful), then is where we have the issue. A new blank (as in no content) file appeared. the file name and tab are both named "sheet1". This is NOT a file within the folder. In addition, the macro did not finish to summarize the folder conents... which I already know it is capable of doing. Any ideas on how to fix that part?

[Webbers]

My Code looks like this now, with the addition you had me make PJ. However, I do not understand what is happening with the opening of this NEW balnk worksheet and the macro now running at all.

Please Login or Register  to view this content.