nak bukak file dari excel

kengkawan,,
sape tau cam manew nak export file pkai vb dalam excel,,
situasi :
- bile clik command buttuon,, dew akan appear file yng kite nak,,
- cntoh file :.txt
same yng bleh tlg??

k,, now how to ganerate txt file??
using vb excel?

[quote="sharina"]k,, now how to ganerate txt file??
using vb excel?[/quote]
cntah txt file



DR MOSS 12563 43 THE STREET CANTERBURY 01899 852258 Telephone calls 21/3 0000014.63
PROF FLOWER 1225 28 NORTH ROAD MARGATE 01899 562236 Room hire 14/3-16/3 0000085.00
MISS DAISY 15523 26 MARGATE DRIVE WHITSTABLE 06223 223556 Damage to desk 0000122.32
DR WEED 1300 GATSBY, DOVER AVENUE PADDOCK WOOD 06223 224514 Overpayment in June 0000048.60
DR BINDING 13330 224 CANTERBURY STOUR CANTERBURY 01688 512555 Telephone calls 24/3 0000005.23
MR GREENACRE 25336 RED FARM, STURRY RD CHARING 01899 852114 Mess bill - extra milk 0000014.50