File extension in upper case

Excel Help for File Extension In Upper Case in Developing Business Administration Solutions

File Extension In Upper Case

Rate this: (3/5 from 1 vote)

	The error is due to the file extension in upper case. The file name is test4.PDF. It works if we save the files as test4.pdf or change the VBA code to lower case the file extension: VBA Code: 'get collection of pdf files While strFile <> ""    If LCase(Right(strFile, 4)) = ".pdf" Then         colFiles.Add strFile    End If   strFile = Dir Wend
	Excel Business Forums Administrator
	Posted by Excel Helper on 14 May 2014

View Full Post