Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Print to file limited the no of character in a row?
Take a look at VBA's help for Tab. You'll see that it uses the "Width #"
statement. Since Width is limited to 255, I think you should just drop Tab() and use Space(). Print #FNum, vIER; space(7); vLPAR; space(17);....... Leslie wrote: 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!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells limited to ~253 characters unless source file open | Excel Worksheet Functions | |||
Limited character display | Excel Discussion (Misc queries) | |||
Limited Print Area | Excel Discussion (Misc queries) | |||
importing undelimited text file data, character-by-character | Excel Programming | |||
How to convert De-limited text file to excel | Charts and Charting in Excel |