I have a file which is sorted my ID. I would like to check each ID to see if the member has any claims within 60 days of the prior claim (same date does not count), If they do I would like to put a "1" in column "F". Attached is a sample file.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.