![]() |
|
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Newbie
|
I have a dilemma
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. |
|
|
|
|
|
#2 |
|
Man Bear Pig Hunter
Join Date: Jul 2005
Location: NorCal, USA
Posts: 290
Rep Power: 4
![]() |
No, this doesn't fit here either. I'd remove it before you upset more people with your spamming. No offense, just trying to help you out.
|
|
|
|
|
|
#3 |
|
Newbie
|
I want to remove it from the other threads, i cant figure out how?
|
|
|
|
|
|
#4 |
|
Hobbyist Programmer
|
Ask Big K or a mod
|
|
|
|
![]() |
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|