Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 128
  • Last Modified:

Writing a macro for my VB App

I want to give users the ability to record a macro when using my vb app. I then need a way for them to play it back. Anyone have any code that will achieve this?
0
alaplume
Asked:
alaplume
  • 3
1 Solution
 
rspahitzCommented:
Listening, but here's some thoughts...

If your app is an ActiveX Executable, then you will have exposed various properties, methods and events which will become the Object Library interface.

After these are exposed, the app can be added to a VBA session and manipulated through VB in the same way that Word, Excel, etc. are manipulated.

I suspect that the only difference between Word and your app is that Word has a few extra commands that instantiate VBA with some customized items specific to the object library.

Maybe that's all there is to it, but I've never tried it so I'll see what else comes up from other experts.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now