Is there any way to write a macro that saves a spreadsheet as a text file so that the text file format is extremely precise.
Example:
Line 1 will have 5 total charachters spaces. The first charachter will always be a "W" and the remaining four will be numbers (0000 to 9999).
I.E.
W1234
Line 2 will have 200 charachter spaces. The first charachter will always be a "Z". Charachters 2-21 will be a and ID #. Charachter space 22 will be a "J". Charachter 23-34 will be the Customer Number. Charachters 35-42 will be the customer Ship-To. And so on...
I.E.
Z15433465...........J14564853....MAIN2133
(Without the periods though. I had to use those to show the number of spaces between specific areas)
Both of these together would have a text file like this....
W1234
Z15433465...........J14564853....MAIN2133
There is much more that goes into this, but just getting this format off the ground would be a huge help.
Thanks
Example:
Line 1 will have 5 total charachters spaces. The first charachter will always be a "W" and the remaining four will be numbers (0000 to 9999).
I.E.
W1234
Line 2 will have 200 charachter spaces. The first charachter will always be a "Z". Charachters 2-21 will be a and ID #. Charachter space 22 will be a "J". Charachter 23-34 will be the Customer Number. Charachters 35-42 will be the customer Ship-To. And so on...
I.E.
Z15433465...........J14564853....MAIN2133
(Without the periods though. I had to use those to show the number of spaces between specific areas)
Both of these together would have a text file like this....
W1234
Z15433465...........J14564853....MAIN2133
There is much more that goes into this, but just getting this format off the ground would be a huge help.
Thanks
Last edited: