I have a macro that runs a series of 20-25 queries, a function at the end. What is the VBA code for simply creating a blank text file and copying to a folder.
File Path: C\MyShare
File Name Name Must be: accessdone.txt
My developer wrote a code that emails reports when my macro is done, he wants a file dropped in a specific folder on our network with a specific name.
Is this possible?