ExcelBanter - .FileType = (.csv files) ??

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - .FileType = (.csv files) ?? (https://www.excelbanter.com/excel-discussion-misc-queries/147399-filetype-%3D-csv-files.html)

Dave

.FileType = (.csv files) ??

Hi Guys,

I have a Macro that contains the line:

..FileType = msoFileTypeExcelWorkbooks

I want this macro to be able to find both Excel Workbooks AND .csv files.

How would I do this using the above format?

thanks
Dave!

All times are GMT +1. The time now is 02:45 PM.