Need to make txt sheet with specific fields taking up a specific number of spaces.

Hello hello! I have data I ultimately need to be in a .txt file that is sent over FTP to a database. Each space counts, and each field has a specific amount of spaces that need to be there before the next field is entered. There is software to correctly do this, but it has no option of importing files to pull data from, all the data has to be manually typed in. Right now I use a keyboard and mouse macro to copy and paste data from my excel sheet to the software, but would like to have excel just go ahead and write the data file for me.

Here is a link to the description of what the requirements are:

http://www.myfloridalicense.com/dbpr...uctions_09.pdf

it is on pg 16

Each table and spaces talked about within are 1 line. The next table is the next line down.

@ajca01

I have done these types of files for our EDI Invoices for our company to be able to upload Invoices to stores databases. I have attached a sample of a macro to add spaces to the end of the field. Now I dont know if any of your fields will be bigger then the field size but I can handle that also. Just would need to know how you want to handle it. Ex: If field size is 4 and the value is MikeJ I can get Mike and add it to the txt file or throw up error message.

Heres a small sample,

Space Sample.xls

@ajca01,

Here's an example that will create a txt file. First save the attatched workbook to your computer. The output of the txt file will be in the same folder as the workbook folder. Without knowing the structure of your Excel file that you are needing manipulated into a text file its hard to make an example. So this should give you an idea, also its only an example of Record Type 1 (Provider Record).

Space Sample_v3.xls

Let me know more of your data structure in your workbook and Im sure I can make your life a little easier.

Thanks Mike