Finding a folder with today's date

I'm looking for a vba that will find a folder with today's date formated 07112016 using excel macro. I want the macro to able to find a spreadsheet that contains "pay.gov" excel file in today's formatted date folder. And be able to page break a row before a value of a cell. For insrance, the first column, will contain the "transaction" so I want the page to break a row before this. And save as pdf in the same folder to be filenamed based a name field. For instance, the first column will have a field "payor", then the column after this will have the name of actual payor which is the name of the filename I want to be saved as pdf in the same folder.

But if the payor is the same for each transaction, then add a number after the payor''s name in the filename.

After reading what i just explained, my concern is there are several pay.gov spreadsheets in the same folder. So it might cause an issue? Because I do want all of pay.gov spreadsheet to perform what i just mentioned. There is however another name with the pay.gov filename. So what if we add if the filename contains other value, do the same function and not loop it again because it is done the first time?

Let me rephrase:



I'm looking for a vba that will find a folder with today's date formated 07112016 using excel macro. I want the macro to able to find a spreadsheet that contains "pay.com" excel file in today's formatted date folder.

For example:
C://user/document/FY2016/July/07112016

Open one of the pay.com spreadsheets.

For example:
Pay.com creditcard.xls

Then be able to make sure all rows are fully open (does not hide the details in the rows) and page break a row before a value of a cell. For instance, the first column A, will contain the "transaction" so I want the page to break a row before this and auto page fit to one page for each of the page break. Then save as pdf in the same folder to be filenamed based name fields for each payor.

For instance, the first column A will have a field "payor", then the next column B on the same row will have the name of actual payor which is the name of the filename I want to be saved, plus if column D contains one of the business name:

Citibank
Chase
PNC

then include it with the filename and current month and current Fiscal Year to be saved as pdf in the same folder.
For example:
Mike_Citibank-Jul FY16.pdf

But if the payor is the same for each transaction, then add a number after the payor''s name in the filename.

For example:
Mike_Citibank(1)-Jul FY16.pdf

This spreadsheet can have many payor so I want it to loop until all of the payor are each filenamed into pdf.

But once the files have been saved to pdf, close it and move the excel files to a backup folder within the path.

For example:
C://user/document/FY2016/July/07112016/backup

Originally Posted by preciouslife73

After reading what i just explained, my concern is there are several pay.gov spreadsheets in the same folder. So it might cause an issue? Because I do want all of pay.gov spreadsheet to perform what i just mentioned. There is however another name with the pay.gov filename. So what if we add if the filename contains other value, do the same function and not loop it again because it is done the first time?