Hi ,
I have a requirement to create a fixed length text file from excel.
INPUT EXCELSHEET
Country salesperson
2 4
USA John Smith
The second row in above example contains the length of the expected output in the text file. Hence, the expected output in the text file should be as follows.
US John
I need the code to be written inside a macro to achieve the above purpose.
Kindly help.
Regards,
Soundarya
I have a requirement to create a fixed length text file from excel.
INPUT EXCELSHEET
Country salesperson
2 4
USA John Smith
The second row in above example contains the length of the expected output in the text file. Hence, the expected output in the text file should be as follows.
US John
I need the code to be written inside a macro to achieve the above purpose.
Kindly help.
Regards,
Soundarya
