Creating macro from visual studio

Hi,

I am working on creating an add-in in excel 2007 using visual studio 2005. I need to create a browse button in one of the cells in excel and i need to do it dynamically from visual studio. I have been able to create a form control button but, it needs a macro as its on-action event.

The problem is how to create a macro dynamically. I can then write the code for file open in the macro.

Does anybody know how to do it?

Thanks,
Dhruvan.

Hello Dhruvan,

You would be better off posting this question in a forum that deals with Visual Studio programming. This forum deals with Excel programming using Visual Basic for Applications. Click on the link to see a list of VS links. Visual Studio forums

Sincerely,
Leith Ross

Hi,

Thanks for the info

Dhruvan.