Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileSearch using FileType
Dear all,
I've read some articles in this group, where is reported that FileSearch has some problems, but I didn't found my problem: I use Excel XP SP3 with WIN XP SP1. When I use ".FileType = msoFileTypeExcelWorkbooks" then I get not only the XL-files, I get all other files (*.doc, *.txt, etc.) as well. Is there anything special what I have to observe? Thanks for your contributions Werner |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileSearch using FileType
Werner,
In my tests that works fine. Can you show us the full code? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Werner Rohrmoser" wrote in message oups.com... Dear all, I've read some articles in this group, where is reported that FileSearch has some problems, but I didn't found my problem: I use Excel XP SP3 with WIN XP SP1. When I use ".FileType = msoFileTypeExcelWorkbooks" then I get not only the XL-files, I get all other files (*.doc, *.txt, etc.) as well. Is there anything special what I have to observe? Thanks for your contributions Werner |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileSearch using FileType
Bob,
bottom line: I have to take care using .FileName and .FileType together. Thanks. Werner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read from filetype | Excel Discussion (Misc queries) | |||
.FileType = (.csv files) ?? | Excel Discussion (Misc queries) | |||
Macro to change filetype .dat to .xls | Excel Programming | |||
csv for filetype property of filesearch object | Excel Programming | |||
File name seach within open filetype | Excel Programming |