View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LESLIE LESLIE is offline
external usenet poster
 
Posts: 113
Default 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!!