Search:

Good News! I solved my own problem(s). Basically had to make sure that my Range and Selection statements had the appropriate parent objects specified. Corrected code is shown below:

Dim oExcel...

Yes, K2Rng does have a value. I started a new thread as you suggested. I also added the missing lines where K1Rng and K2Rng are defined.

STARTED NEW THREAD************************

I am having an issue where Excel doesn't close when it should. Here is a very simplified version of my code. If I remove the code identified as...

Did anyone ever post a working reply to this problem?? I am having the same issue that Fred describes. Here is a very simplified version of my code. If I remove the code identified as "Problem...

I had a similar problem when I first switched to Access2007 (when trying to connect to .accdb database files).

If you were using the Microsoft DAO 3.6 Object Library, try removing the...

I've got a VB6 front end to an Access2007 database. I'm using the Microsoft Office12 Object Library and standard DAO type commands to query/read/write to the database. Typical commands to open the...