ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Print to file limited the no of character in a row? (https://www.excelbanter.com/excel-programming/349170-macro-print-file-limited-no-character-row.html)

LESLIE

Macro Print to file limited the no of character in a row?
 
I'm trying to output the contents of the cells in Excel to a txt file with
the Print # method. But the result is the output is divided into 3 lines. I
wonder if there is a limit of the no. of character allowed in the txt file
when using Print # method. The following is my code:

Print #FNum, vIER; Tab(7); vLPAR; Tab(17); vCHL; Tab(37); vMQM; Tab(49);
vTYP; Tab(57); vEXT; Tab(58); vOCL; Tab(1058); vOSC; Tab(2058); vEDATE;
Tab(2088); vTDATE; Tab(2118); vHDATE; Tab(2148); vJDATE; Tab(2178); vSTAT

Is there any way to print all the contents in a single row? I know it's a
bit too long (more than 2000 chars), but I have to upload the txt file into
the AS/400 Database file which I have to get all the data align with the
predefined format of the table.

Thanks in advance!!


All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com