I have two projects and would like a pricing for each and combined if that reduces the cost. The first project is a debugging project. I have a VBA created that looks at two output files and compares them. It will then generate a new output file base on the difference. The comparison occurs based on several factors, the BUIDs Length 9, Start position 23, edit 31. The NDC 11, 86, 96; the sf indicator 1, 203, 204. And I think the date 13,10, 22. The difference is four 3 fields, rxs, length 8 start 99, end 106; the units 12, 107, 118, and the price 12, 121, 132. The VBA works except for the price. Occasionally this comes with an odd output that is not the correct math. I cannot find what is causing this error. I have include the excel file Reconciler, with a sample of data with an error occurring it can be clearly see on “parsed Dif” G29 and G30.
The second project is creating from scratch. I have trying to create a VBA but I have not been successful. I think this one should be a bit easier. This is the COBI QA. What should occur is the output file should be places in the CARS tab. A user will press the MACRO and the file will be parse out in to columns in the Parsed tab then a sql should run pulling information from the database as placing this is the QA tab. I will be adding cells to compare these results with the parse file. The parsing occurs by text to data delimited by the character | I have attached a copy of an output file. I have also attached the sql I would like to use. The sql will need to have variables changes based on the values in column J.