Create this text file with vba

[Fairlane]

We use bartender to create labels and I need this output in a text file. The header is code to run and I know how to handle the characters in vba.
The sample below is ~ delineated


This is a sample output needed.

%BTW%C:\PROGRA~2\Seagull\BARTEN~1\BarTend.exe /AF="\\F99-HyperV-TS1\Bartender\Tpl\WHSE ITEM.btw"/P /X /D /DD
%END%
1~VA0764~fesl~99-Inv~01-A-01~MSI VLV, 2'' X 2''1502, STD HI-TEMP, W/ AIR ACTUATOR~GC_100~~0~~1~0
1~VA0764~fesl~99-Inv~01-A-01~MSI VLV, 2'' X 2''1502, STD HI-TEMP, W/ AIR ACTUATOR~GC_101~~0~~1~0

My main question is: If I have all the values in a form, how can I export a text file [.txt] that takes this form? I may be able to work around to comma delineated.

[ranman256]

1st build the export SPEC manually (the delimiters)...File export, Select the table, or query to export the data, choose text, then ADVANCED (button in bottom left corner of dialog box)
Set your delimiters, etc and SAVE THE SPEC NAME.

From then on, use the Transfertext command.

DoCmd.TransferText acExportDelim, SPECNAME, Qry, FileName, True

[Fairlane]

How do I get this string appended to the beginning?

%BTW%/AF="\\F99-HyperV-TS1\Bartender\Tpl\WHSE ITEM.btw"/R=3/PRN="\\HV-AX-FILE-SERV\Printronix T5204r - PGL" /P /D="<Trigger File Name>" /DD
%END%

[ssanfu]

It depends...

* Once you have created the text file, you can open it and manually paste it in at the top.

* If the data (label info) is in tables and you use DoCmd.TransferText, you can use VBA to open and edit the text file using FSO.

* If you use VBA to open a query to output the data (records), you would generate and print the string first, then loop through the records of the query, editing the record (the tilde or commas) before printing the record to the text file.

[ranman256]

Instead of TRANSFERTEXT to the final file, export it to BODY.txt
Put your code in a file called HEADER.txt

After the transfer step, the next step is to run a Batch file to assemble the two.
call shell("C:\folder\assemble.bat")

assemble.bat contains:
COPY header.txt + body.txt FINALFILE.TXT

This will produce your final file.