Automation

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.

For comparing one XL file to another, I personally use an Add-in called
XLCompanion. It's available from
[email protected]XX (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




"crowngab" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> crowngab
> ------------------------------------------------------------------------
> crowngab's Profile:
http://www.excelforum.com/member.php...o&userid=24321
> View this thread: http://www.excelforum.com/showthread...hreadid=379255
>