Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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
Avatar of Jacques Bourgeois (James Burger)
Jacques Bourgeois (James Burger)
Flag of Canada image

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.
Avatar of Murray Brown

ASKER

Hi. Thanks very much. How do you cut and paste the results?
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)
Hi. Thanks but I need to do this automatically. I need to find VB.net code that will automate this process.
ASKER CERTIFIED SOLUTION
Avatar of Jacques Bourgeois (James Burger)
Jacques Bourgeois (James Burger)
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks for the help