How to run vba macro from tool

[rajuks]

I have created a new tool pallete and i want to use one tool to run vba macro developed by me. vbarun test1 where test1 is the macro name which needs to be run when i click on one of my tool.

 

Thanks

satya

[GhostRider]

I'm no expert but I have some that use this to call Vba command:

^C^C(command "vbastmt" "test1")

[ZenCad1960]

I have created a new tool pallete and i want to use one tool to run vba macro developed by me. vbarun test1 where test1 is the macro name which needs to be run when i click on one of my tool.

 

Thanks

satya

 

Satya,

 

I do the same thing and I use this format for running the code. (Your code name was placed in the example):

 

 

This next line goes in the "Command String" Line

^C^C-vbarun;Project.dvb!Module1.Test1

 

Hope this helps!

 

Zen

[rajuks]

Thank you very much for your reply and suggestions. i have adopted your suggestions and it is successfully running.

 

thanks once again.

 

satya