The Dir function for VBA learning notes

Dir () is used primarily to obtain (traverse) the file name under the directory

Subopen_all_files ()DimAA=Dir("C:\Users\Administrator\Desktop\ new Folder \*.txt")'all files ending with TXT are opened, but only the first compliant file is opened here, and the next file is opened in the Do loop in turnWorkbooks.Open"C:\Users\Administrator\Desktop\ new folder \"+a Do 'iterates through all the file names in the specified format under the directoryA =Dir'before Dir () has opened a number of files, there is no need to write, to open the format of the file in turnIfA <>""  ThenWorkbooks.Open"C:\Users\Administrator\Desktop\ new folder \"+ A'open each file in a format that matchesElseExit SubEnd IfLoopEnd Sub

The Dir function for VBA learning notes