Murray Brown
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
In a VB.net Excel add-in is there a way to simulate the macro recorder?
Thanks
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)
Then in the Add-In code you do Edit Paste (Ctrl-V)
ASKER
Hi. Thanks but I need to do this automatically. I need to find VB.net code that will automate this process.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for the help
You need to do it in Excel VBA, cut and paste the result in your add-in, and adjust the name of the objects.