Run code with AcadOle object

Ya it's AutoCad 2002 and I'm running it within Autocad but I'm not sure what library to add. I've added those listed in my original post but they don't seem to be enough. I think I'm missing a library that I may have to download or something. Googling has lead me nowhere unfortunately.

Unfortunatly working away from home at the moment.and have limited internet access.

I have copied your post and code and will have a look.

Cant test 2002 but will test in AutoCAD 2000 and check in 2003 and 2005

Look back 29/04/10 and I will try to post for then.

Cheers

Thank you Marcol and romperstomper. You both might be right, it may have to do with my version of Autocad (2002) not being capable enough to run this code.

Marcol's test should clarify that problem.

Also, romperstomper, yes it does use an excel file so what reference library do I have to add to set a reference to Excel. Or do I need to add a few lines of code for that?

Thanks again.

Ok, I added excel and the code works somewhat. The dialog box opens up as the code says to let me pick a file to which some autocad dimensions will be exported to. But then, the excel file is supposed to open up and the data is to be transferred but nothing happens. The program ends after I pick the file.

Does it need a reference in the code for excel?

The VBA editor in AutoCAD is the same as Excel btw and the Tools>References, etc. are all identical to that of the VBA menus in Excel

Looked in the file. Nothing. No update.

It's weird because I copied and pasted A1:C5 from Sample1.xls (attached) and put it into Autocad as a Reference object. Autocad in turn took it but when I double click on the table within Autocad, it opens up a temporary excel file that is not Sample1.xls but rather C:Documents and Settings user-name Desktop Sample.xls (this file cannot be seen, it's not even hidden, it's just not available anywhere). It only appears when you double click on the little table within autocad.

My autocad file has a little blurb about what I need happening if possible so it might help eliminate some confusions.

Please view the attached files. I have attached the sample.dwg as a pdf so you cannot see what I mean about the temporary excel file.

I can't check 2002 but a similar error appears with 2000. I think the next significant version after 2000 was 2003.so it is fair to assume that 2000 does not support AcadOle objects.

The code runs with a little tweeking and weeding in 2003, 2005 and 2008.

Does 2002 have
1/. Tools > Data Links > Data Link Manager....
2/. Draw > Table....

Possibly not, but this makes for an easy solution in versions that do.

I think the solution is to revert to DBconnect, I have limited access at present to the internet so lookback 30-31/04/2010 when I hope to have a solution for you, I'm a bit rusty on the 2000 stuff.so bear with me, It was 10 years ago after all !!!

Cheers
Alistair

Alistair,

I don't see a Tools>Data in the VB editor or in Autocad. I doubt it exists in 2002. A quick google search revealed that it was introduced first in 2005.

I will wait for your reply I guess because I'm out of ideas at the moment.

Thanks for your efforts.

Aye, that's what I thought, but wasn't to sure.

I'll try it the old fashioned way, DB connect.

Got to sign off shortly look back tomorrow or the day after

Alistair

Ok. I will do some research on DB connect in the meantime because I've only ever heard about it. Never even seen someone using it.