Recent content by kelvin78

My apologies as I wasn't aware of this. I'll try with the earlier sample and see if it works out.

Re: Simple Software Solutions Hi, Is it possible to share a sample database to show how exactly this works with two recordsets and a third table that shows the differences? I'm very new to VBA and have done some basic functions but I still can't get around understanding your sample code...

So that's what the pop up meant. Thanks again!:p Another day...another new thing to learn.

Hi namliam, Is there any way I can keep the formatting and layout when I use TransferSpreadsheet to export queries to excel sheets?

Hi ByteMyzer, I could not get the sub procedure to work correctly as it keeps giving me the below pop up: "Expected variable or procedure, not module." Sub procedure was placed in a standard module. Even testing the procedure in the Immediate Window with the below parameter, I keep getting...