VB.net simulate the VBA macro recorder

Hi

In a VB.net Excel add-in is there a way to simulate the macro recorder?

Thanks
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Jacques Bourgeois (James Burger)PresidentCommented:
Maybe I did not understand your question correctly.

Is this something you want to use for your own development, or is this a feature that you wanted to have in your application.

If it is a feature for the application, then you have to licence Visual Studio Tools for Applications. Since I do not have any experience with that product, I won't tell you more about it. You can search for it, maybe looking at http://blogs.msdn.com/b/dr._ex/archive/2005/10/03/476435.aspx for a start.

0
 
Jacques Bourgeois (James Burger)PresidentCommented:
No.

You need to do it in Excel VBA, cut and paste the result in your add-in, and adjust the name of the objects.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi. Thanks very much. How do you cut and paste the results?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Jacques Bourgeois (James Burger)PresidentCommented:
In the resulting VBA macro code you do Edit...Copy or Cut (Ctrl-C or Ctrl-X)

Then in the Add-In code you do Edit Paste (Ctrl-V)
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi. Thanks but I need to do this automatically. I need to find VB.net code that will automate this process.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.