Automation

[crowngab]

Hi,

Please i need a way around this stuff quickly. I
deal with large excel
files and usually have to comapare an electronic
copy (current) and a
hard copy (downloaded from a server a week earlier)
and make some
remarks on the new one.

I could actually lay my hands on the electronic copy
of the older
list. The prob now is that how do i automate the
process and let the
program (excel or any other u might suggest) note
the missing rows
(numbers) in the newer and give a PASS remark on the
newer one?

I have tried all the tricks i know about writing/
recording excel
macros and vba to no avail. Please help out!

Any suggestion might be useful.

Thanks.

 

[CLR]

For comparing one XL file to another, I personally use an Add-in called
XLCompanion. It's available from
(e-mail address removed) (remove the XXX's)

It really saved my bacon.......... when having to compare two Excel files
that were "supposed to be the same".......it found 231 differences.

I whole-heartedly recommend it.

Vaya con Dios,

Chuck, CABGx3