fixed width

  1. M

    Array to Text Output

    Ok, I have string array with values that have leading or trailing spaces or zeros to make the values correct for a fixed width file. Does anyone know and easy way to export the array as a text file with no formatting so it will be a proper fixed width text file? Thanks, Matt
  2. P

    String Parsing Guidance

    Hi All I was wondering if all you nice Access Gurus could provide me with some guidance. I am used to working with comma deliminated text files and parsing them into a table. However I am now getting Fixed width datafiles and the Person's name for each record is no longer comma delminated...
  3. K

    can I Import Multiple Fixed Width Files at once

    Is it possible to import multiple fixed with files at once? I can make the following work, but I do not know how to allow the user to search for a file. Sub OpenTextFile() Const xlFixedWidth = 2 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Set...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top