Validate headers before uploading in excel

[vcse]

Hi

I'm using Excel 2010.. Here's my problem. I try to copy all the data from one excel workbook(source.xls) to another (calculate.xlsm). Its a table with headers 7 headers. Now in that 3 header values are mandatory to do some calculation. So during upload process i need to validate all 6 headers are present.

Source.xls

ID FName LName Addr1 Addr2 Postal Phone
101 aaa xxxx asdf 12345 09876
102 bbb yyyy fdsa 4321 342345

In my calculate.xlsm i need to check ID, Fname, LName headers are there or not. I dont worry about the data.

[LJMetzger]

You probably need something like this:

Please Login or Register  to view this content.

[vcse]

Hey Thanks for your help..

In your code how i validate all 3 header values ..ie., ID, FName and LName..

Thanks for your faster response

[LJMetzger]

Repeat the following as required:

Please Login or Register  to view this content.