fixed length

Hello all, Hoping to find some assistance with a pesky task. Each week, I run a report that produced a text file. This task is going to be handed off to other individuals with limited Excel experience and need to automate as much as possible. I have been successful in prompting the user to...

Hello all, I am a practicing VBA'er but this one is really tricky for me. I have a set of weights that may range from .01 lb all the way to 1.5 lbs lbs all with different decimal points.. Example: Before__________After 0.1845 becomes 001845 1.054 becomes 010540 1.16 becomes 011600 1.116...

i'm working on a VBA code in which i need to define each field as a specific length, and justify (or pad) the empty spaces. each column needs to be defined a specific length and will not change in the future. i'm thinking i need to define the range as a string, with a fixed length type...

My first time posting. I need help to create a text file from Excel that can be imported into my Accounting system which requires a fixed length records. I am having trouble outputting the number fields in the correct format. These number fields must be 12 positions of which 2 are decimal places...