#Tinyterm captured not writing to file code#
#Tinyterm captured not writing to file zip#

If not, we'll have to move to a more complicated scheme).Ĥ) On the second row of the record, customer name is at position 11, Vendor Name is at 51, and part# is at 65.ĥ) On the rest of the rows (until the next row of -), customer address is at position 11 and Vendor address is at 51. (This is just based on what you pasted in, and can be changed easily as long as the info is in the same place for every record.

#Tinyterm captured not writing to file zip#

I'm going to move foward with the following assumptions (all subject to change, but it's a starting point):ġ) For records with more than 5 rows, the additional information is considered part of the customer or vendor address (addr3, addr4, etc), depending on its position in the row.Ģ) The 'City, State, Zip' row is the last row of each record (this is important because if city, state, and zip are in separate columns, the macro needs to know to split that row on commas rather than spacesģ) In the first row of the record, ACCT# starts at character 1, Description starts at character 14, Value is at 32, Curr is at 42, Date is at 53, and Info is at 62. Well.this will be a challenge.but I've always liked a challenge Very Regualry at least 100 times per day by end users that may not be very strong in these types of activities so I want to try and keep as simple as possible for the end user.

Well, all of the headers that will make up the 26 columns of data is not captured in the actual report output, so if I need row 1 of excel to state what the data is beneath it I will need to do that at the end or start the data paste from TXT file to Excel in Row 2 instead of Row 1 I would not say that their are characters separating the data but I would say it is fixed.ĭo you want to know what each column of data is actually going to be? No, just the line of '-' to seperate each entry. Then the report starts, you will have 5 or 6 or 7 lines of text that make up one entryīetween each entry you will have a row of '-' as a visual seperator and of course to seperate between each entry that eventually i want on its own row in excel. Row 6 is A row of '-' as a visual seperator Row 4 is A row of '-' as visual seperator Row 2 is A row of '=' as a visual seperator Then the header on each page after that is 4 lines

To try and make sure I answer each question with as much detail and to keep a good line of communcation I will reply underneath your question. I appreciate your help and looking into this for me. I know there are a lot of questions here, but I've written several macros that convert text files into Excel, so I think if you can answer those questions, I can help you.

Some are yes/no.others may not be so easy.ġ) Is there anything in the first header row that distinguishes it as a header? (A specific word or phrase that's not anywhere other than in the headers, perhaps?)Ģ) Are there labels before the data elements on each row?ģ) Is there a blank row (or anything else) between the groups?Ĥ) Is the data fixed width (everything lines up) or delimited (some character separating the pieces of data)?ĥ) You mentioned 28 columns.can you give one example output of what you want in each of the 28 columns? I only counted 22 in your layout, including headers.Ħ) Do you want the 3 header rows captured and put into 3 cells for each row? Or is the header the same for the whole report?ħ) Will you repeat this process on a regular basis, or is it an infrequent task?

#Tinyterm captured not writing to file code#

I've read your description and reviewed your example a couple of times hoping I could post some code right away that could get you headed in the right direction.but I have too many questions. There are a couple of elements of your text file that will be key to getting this 'translated' correctly from electronic report into an Excel worksheet. Thank you for your suggestion - but already done that and tried that.ĪCCT #_DESCRIPTION_VALUE_CURR_DATE_INFO1_