Excel sheet contects are to be formatted into some specific format

S

Santhu

Hello all,

I have excel sheet as below
----------------------------------------------------------------------------------------------
Col1 Col2 Col3 Col4
Col5
Project Team Application Project ID Department Divisio
-----------------------------------------------------------------------------------------------
..NET Stds .NET Stds Remove Stds S3 Arch S3
..NET Stds .NET Stds Remove Stds S3 Arch S3
..NET Stds .NET Stds Remove Stds S3 Arch S3
ACES Dev ESA Sys ESA Enhance ACES Servicing
ACES Dev ESA Sys ESA Enhance ACES Servicing
ACES Dev ESA Sys ESA Enhance ACES Servicin
------------------------------------------------------------------------------------------------
Proj Team , Application, ProjectID are sorted on one other. There are some
3000 rows in this sheet

I need this content in this format

$VALUE
.DISP_ORDER 0
.COL1 .NET Stds
.COL2 .NET Stds
.COL3 Remove Stds
.COL4 S3 Arch
.COL5 S3

$VALUE
.DISP_ORDER 1
.COL1 .NET Stds
.COL2 .NET Stds
.COL3 Remove Stds
.COL4 S3 Arch
.COL5 S3
$VALUE
.DISP_ORDER 2
.COL1 .NET Stds
.COL2 .NET Stds
.COL3 Remove Stds
.COL4 S3 Arch
.COL5 S3

and so on....................
I want this output into a text document

How can i create a macro to do this? Can anyone please help me with this.
 
Top