ExcelBanter - csv for filetype property of filesearch object

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - csv for filetype property of filesearch object (https://www.excelbanter.com/excel-programming/318958-csv-filetype-property-filesearch-object.html)

smokiibear

csv for filetype property of filesearch object

can .filetype be set to csv when using the filesearch object?

Thanks.

Smokii

Bernie Deitrick

csv for filetype property of filesearch object

Smokii,

Su

With Application.FileSearch
.NewSearch
.LookIn = "C:\"
.FileName = "*.csv"
.....

HTH,
Bernie
MS Excel MVP

"smokiibear" wrote in message
...
can .filetype be set to csv when using the filesearch object?

Thanks.

Smokii

smokiibear

csv for filetype property of filesearch object

what are the limitations to .filetype? is it just msofiletypes?

Smokii

"Bernie Deitrick" <deitbe @ consumer dot org wrote in
:

Smokii,

Su

With Application.FileSearch
.NewSearch
.LookIn = "C:\"
.FileName = "*.csv"
....

HTH,
Bernie
MS Excel MVP

"smokiibear" wrote in message
...
can .filetype be set to csv when using the filesearch object?

Thanks.

Smokii

Tom Ogilvy

csv for filetype property of filesearch object

Yes. only the constants in msofiletypes

--
Regards,
Tom Ogilvy

"smokiibear" wrote in message
...
what are the limitations to .filetype? is it just msofiletypes?

Smokii

"Bernie Deitrick" <deitbe @ consumer dot org wrote in
:

Smokii,

Su

With Application.FileSearch
.NewSearch
.LookIn = "C:\"
.FileName = "*.csv"
....

HTH,
Bernie
MS Excel MVP

"smokiibear" wrote in message
...
can .filetype be set to csv when using the filesearch object?

Thanks.

Smokii

All times are GMT +1. The time now is 08:34 AM.