c0z420

Ok...i have a little dilemma here @ my job that i'm trying to figure out how to solve. So here goes...

We run a job in a Reflections Session that produces reports. After they are finished the reports are tranfer out of their to a place on our network in "txt" documents. We then run a program that will post them on a part of our Intranet for our business office to view. The problem is, we (Computer Operators) @ night have to look @ about 3 of the reports and make sure there are No errros between figures. So for example we have a Beginning AR, a Net Change, and an Ending AR on one report that we have to actually open an EXCEL document and put those figures into. WE have to do this for a few other reports into another excel document. The thing is, we would like to Automate this somehow that it can check to see if there are any Errors in Figures and then post them into an excel or even access database automatically for archiving. Any suggestions...??? At our last meeting one of the guys suggested doing it all in VB. I tried doing Macros in Excel and tried fiddling with Access but it really wasnt working much. Let see how many ideas we can get flowing, i'll take any suggestions.

Ghost

Now your just being a problem, it wasn't bad enough you spam this message in almost all the forum cat. you have to do more than one in each cat.

Not cool.

c0z420

I said im sorry like 100 times.....i didnt know who to ask geezus. Didnt know eveyrone checks every section of this forum...ususally people dont.

Rory

People do regularly check these forums. Sounds like you should use VBA (for office) for this, if you've no idea at all, try recording macros and see the code produced.

Ghost

Rory, he means did didn't know that people check more than one topic, such has this was posted in (ASP, Javascript, VB, VB.NET, HTML, And more maybe).

c0z420

I've been trying to use Macros in Microsoft word....but how would the code know for what exact file to check.... i mean they are labeled @ the end of the file by the date..such as .... file1228.... where 12 month....28 day....obviously. So i could record the macro....have it open the file from the specific day....find the numbers it needs in the file....copy then? put them in another excel file or access database mabye? or am i just gettin off track here...and some how compare those numbers.

I wish i could do it all from excel but the problem is, theres alot of data that we really dont need in these output files....we only need like 1 line of data out of like 5-6 pages of reports. So i'm just wondering how we can get the numbers we want from the reports....compare the numbers....make sure there are no errors in the figures....which means that the difference will be 0, and the last report u compare 3 differnt reports and make sure all the grand totals match and are the same value.

What we have now is........theres one report...which we take 3 vaules off of one line of the report....beginning Ar, net change, and Ending Ar....we put those values in an excel sheet....we then open 2 other txt files from our intranet page....and they should be the same value as the net change in the first report. The next 3 reports are AR reports that just checks the grand totals.... and all 3 should be the same value.

coldDeath

I'm just going to take this moment to congratulate Rory for his festive avatar.

__________________

Rory

Lol thank you. On which subject, where did :banana: come from, and what particular emotion is it meant to symbolise?

EDIT: Happy New Year!

coldDeath

There was a whole thread about the banana, from what I saw, it came from "Peanut Butter Jelly" :-)

__________________