ExcelBanter - Test a file to retrieve format

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

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

- - Test a file to retrieve format (https://www.excelbanter.com/excel-programming/285649-test-file-retrieve-format.html)

Ago

Test a file to retrieve format

Hi,
I have to test a file in a dir from VBA (Excel 2000) to
verify if the format is Excel, csv or other.
Do anyone know how this could be done?

Thank you

Ago

Jim Rech

Test a file to retrieve format

I think you have to go by the file extension. To actually open the file and
examine its bytes would be a tough row to hoe.

--
Jim Rech
Excel MVP

All times are GMT +1. The time now is 01:39 AM.