Pages
Home
Excel VBA
Excel Online Course
Excel Powerquery
Contact Us
Aug 14, 2009
Show all the file within a folder
Sub showFiles()
fn = Dir("C:/update/" & "*.xls") ' the first file name in the folder
While Len(fn) > 0
MsgBox fn
fn = Dir ' the next file name in the folder
Wend
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment