DOH! I created a vba app accross ACAD/EXCEl/OUTLOOK, what do I do with multiple Environments?

I created a vba app accross ACAD/EXCEl/OUTLOOK, what do I do with multiple
Office Environments?

Half of the drafters have Office 2000, and half Office 2003. The object
libraries obviously don't match.

(I am new at this...)

We are all on ACAD2k5. The app was developed in O2K3. I am vaguly aware of
compiling the code, but I know that there is a lot of work needed in order
to create an.dll or .exe. Am I correct that much of the code has to change
from .dvb to create a compiled .dll or .exe?

I do have Visual Studio 6 in the office.

Some problems I have already encoutered in the test I ran quickly to cimpile
is:

ThisDrawing. (errors)

End (errors)

Thats just the beginning.

Any advice is appreciated.

 

Hey Dan,

Yeah, creating something in VB6 would be better in the long run. In the
short term, what are you saying you have now? I reads like you just have
one vba file but office can't open a dvb and autocad doesn't use vba files.
Do you have a vba file for each app? If so, in the office ones, you have to
make a refernce to the autocad library and you have to declare/assign an
application and a document variable. You use the document variable
everywhere you'd use ThisDrawing. On the AutoCAD side, late bind to office.
In laymen's terms, find EVERY office object you declare and change them all
to As Object. Then remove the reference to Office.

-- Mike
___________________________
Mike Tuersley
CADalyst's CAD Clinic
Rand IMAGINiT Technologies
___________________________
the trick is to realize that there is no spoon...

 

Yup, I hear you. Thanks Mike. I just read about late binding. I appreciate
the help. Currently, I just opened up the .dvb file on the Office 2000
machine, and changed the Reference Object Libraries to the Office 9, and
Outlook 10, which match their machine, and Saveas a 2K.dvb version. It works
for now, but in the long term, I will want to compile the code. I am
researching it now, and what you said is correct. I appreciate the help
again.

Dan