Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ago Ago is offline
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
retrieve an old file erased by saving a new file with same name Nagesh Adoni Excel Discussion (Misc queries) 1 March 28th 07 02:45 PM
Can I retrieve a value and its format using the minimum function? daled Excel Worksheet Functions 1 November 2nd 05 09:38 PM
If I accidently replace a saved file can I retrieve the old file? kamabiv Excel Discussion (Misc queries) 1 May 11th 05 10:26 PM
Anyone know how to retrieve a deleted file (file has a name, comp. Patinak New Users to Excel 2 April 3rd 05 08:53 PM
retrieve value in file (NO VBA) Mire Excel Programming 7 September 4th 03 05:07 PM


All times are GMT +1. The time now is 05:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"