Running sample VBA code

[BIGAL]

I am trying to run some of the sample VBA code within C3D 2009 about creating surfaces the module is surface operations.

 

I am self taught re VBA but I can not get this module to run it always gives me an error can not find project or libarary what am I doing wrong. I have a lot of other code part ready to interrorgate the civ3D database but need sample to work to understand some more.

 

Here is the sample file

SurfaceOperationSample.zip

[CmdrDuh]

I cant download it here at work, but did you add all your references and type libraries?

[BIGAL]

Went back a few more steps and run some of the other sample modules which worked they create a new surface project so will look at how they initialise the connection to the surfaces database. But anyone else out there using CIV3D and knows about VBA help would be appreciated understanding which modules are required.

 

Just to explain what I am trying to do when changing surface properties it can take 4 mouse clicks, a scroll down, another 2 clicks and all I have done is turn off the contours displayed multiple this by the number of surfaces and it can be very long winded. The desire is a toolbar with multi options contours on / off, select preset intervals, set default surface ie 1 click for most options. Once done will paste code back here for other CIV3D users.