Writing Excel data to 2 separate text files

Hello VBexperts, VBenthus and VBnewbies,

I am newbie to the world of VB and also to this forum.
I need some suggestions or any kind of sample code to read the excel data and write specific columns to my text file. I need to generate 2 text files.

Example of my problem:

My excel file looks like this:

Headers- A B C D
Data - 1 2 3 4
7 8 0 5


One of my text file should contain:

A D
1 4
7 5

The other text file should contain:

C
3
0


Any helps will be greatly appreciated.

Thanks,
new2vb