Run Code Usign Macro

[Guest]

Hi,

I am trying to run a procedure (visual basic - the code has been debug and
in order) by using macro (run code) and I hv create a function to run the
procedure.

By hv the following error msg:

You tried to run a Visual Basic procedure to set a property or method for an
object. However, the component doesn't make the property or method available
for Automation operations.

Wat is this and how to solve.

Thank you.

 

[John W. Vinson]

Hi,

I am trying to run a procedure (visual basic - the code has been debug and
in order) by using macro (run code) and I hv create a function to run the
procedure.

By hv the following error msg:

You tried to run a Visual Basic procedure to set a property or method for an
object. However, the component doesn't make the property or method available
for Automation operations.

Wat is this and how to solve.

Thank you.

Care to post your code? We can't see it, and have no idea what it's trying to
do.

John W. Vinson [MVP]