LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default verify external data before importing

Hi there ,

In my small application i'd like to import a .cvs , .xls or .txt file into a
known sheet.

I'd like to verify the file that will be imported before the data is
imported.
for example : headers need to match or number of columns must be 5 , etc

These are the steps to follow :
1) Click a button to import
2) open the file for verification and verify some data with criteria.
3) if verification is correct = import data , else close file and stop
importing.

Can someone help me a little bit with this one? or point me in the right
direction.
Thanks
Marmo


 
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
Importing External Data Fgbdrum Excel Discussion (Misc queries) 0 July 19th 07 05:12 PM
Importing External Data Donbenz1 Excel Discussion (Misc queries) 0 June 14th 07 09:36 PM
Importing External Data Paul Hammond Excel Discussion (Misc queries) 0 December 15th 05 10:28 PM
Importing external data R. Choate Excel Programming 12 September 30th 05 08:44 PM
Importing external data Glen Mettler[_4_] Excel Programming 2 November 13th 04 04:43 PM


All times are GMT +1. The time now is 07:11 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"