Hello all,
I would like to get help.

I have 4 files in a folder. I need a VBA code that will do this:-

a) open a file that is named " ?????^CV.csv" in this folder

(they are all csv file but only one file will be named as "#####^CV.csv"

How do I set a code to make it find a file name that contains "^CV.csv" in the file name?

Once this file is opened, I need to perform a countA(A:A)-1 to count the number of cells in column A. It needs to subtract 1 because cell A1 is the header.

I need the result of this countA formula to be pasted on the active workbook , on sheet 1, cell "D5"

Once this is done, the "###^CV.csv' file which was earlier opened can be closed without saving.


Thank you all for your help!