Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copyfromrecordset not working
I've encountered a problem with copyfromrecordset that has me
mystified. I set up a program for a guy at work that uses the CopyFromRecordset method and it worked fine until he got a new box. Now, when the program runs, although the recordset is non-empty, not BOF or EOF etc., CopyFromRecordset does not paste anything into Excel. This is for Office 2003, library release 11.0, DAO release 3.6. There are no error messages. I suspect there is something weird about the box because the program runs fine on other boxes with the same Office specs. IOW, this dude has a different model than the others and all others have the same model. ISTM that this would be a bizarre problem, though...Anyway, need some help. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copyfromrecordset not working
Not sure if I or anyone else can help, but it would be helpful if you post
the code your are using... "hawkmoon269" wrote: I've encountered a problem with copyfromrecordset that has me mystified. I set up a program for a guy at work that uses the CopyFromRecordset method and it worked fine until he got a new box. Now, when the program runs, although the recordset is non-empty, not BOF or EOF etc., CopyFromRecordset does not paste anything into Excel. This is for Office 2003, library release 11.0, DAO release 3.6. There are no error messages. I suspect there is something weird about the box because the program runs fine on other boxes with the same Office specs. IOW, this dude has a different model than the others and all others have the same model. ISTM that this would be a bizarre problem, though...Anyway, need some help. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copyfromrecordset not working
I may post it on Monday when I get back to work...but I've learned that
my boss had the same problem. He got a different box, and CopyFromRecordset stopped working. They then gave him the model that the rest of us have, and, hey presto, it worked again. Nothing changed, except the box...Weird... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using ADO to CopyFromRecordset to another sheet | Excel Programming | |||
CopyFromRecordset does nothing | Excel Programming | |||
CopyFromRecordset Bug with Office XP | Excel Programming | |||
CopyFromRecordset does nothing | Excel Programming | |||
Copyfromrecordset Bug ? | Excel Programming |