Test a file to retrieve format

  • Thread starter Thread starter Ago
  • Start date Start date
A

Ago

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
CSV files and having numbers and strings in there... 9
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
VBA- how retrieve source dir for the template *.xlt file ? 7
Which is the best MBOX Converter Tool different formats conversion? 4
Excel VBA help: Text file formatting 19
Date format error with CSV file 6
Testing dynamic range for values 3

Back
Top