Category Archives for "Useful Procedures"

Get file names from a directory

If you want get or print file names from a certain directory, then you can use following code. Sub GetFileNames() Dim sPath As String, sFileNm As String sPath = “C:\DW\” ‘You can also use Application.GetOpenFilename to get a file name from a folder, ‘and then extract the Directory name from that string ‘You can also […]

Continue reading