S smokiibear Dec 14, 2004 #1 can .filetype be set to csv when using the filesearch object? Thanks. Smokii
B Bernie Deitrick Dec 14, 2004 #2 Smokii, Sure: With Application.FileSearch .NewSearch .LookIn = "C:\" .FileName = "*.csv" ..... HTH, Bernie MS Excel MVP
Smokii, Sure: With Application.FileSearch .NewSearch .LookIn = "C:\" .FileName = "*.csv" ..... HTH, Bernie MS Excel MVP