Hi
Need some answers.
Example:
I have the following in columns in Excel:
Column Heading: Name Surname Salary
Row 1 : Jan van der Merwe 10,000.00
I need to export it to a text file with delimted pipes (|) and Name must start at Chr 1, Surname start at Chr 30 and Salary Char 50 - result must look like this.
Jan |van der Merwe |10000
I manage to get it to export but I don't know what code/function I must use to tell vba that I want Jan to start at 1, van der Merwe to start at 30 etc.
Will appreciate the help
Need some answers.
Example:
I have the following in columns in Excel:
Column Heading: Name Surname Salary
Row 1 : Jan van der Merwe 10,000.00
I need to export it to a text file with delimted pipes (|) and Name must start at Chr 1, Surname start at Chr 30 and Salary Char 50 - result must look like this.
Jan |van der Merwe |10000
I manage to get it to export but I don't know what code/function I must use to tell vba that I want Jan to start at 1, van der Merwe to start at 30 etc.
Will appreciate the help