Solved

allow users to record a macro

Posted on 2000-04-21
2
126 Views
Last Modified: 2012-05-04
I'm using a 3rd party desktop application that has VBA inside. I would like to allow users to either a) make a log of their activities (i.e: menu items selected, buttons pressed, keys pressed, etc) or b) record their operations as a macro.  Is it possible for me to delivery this kind of functionality?  If so, what approach would you recommend?
0
Comment
Question by:dannykrouk
2 Comments
 

Accepted Solution

by:
Zymark earned 100 total points
ID: 2738671
Danny,

It depends on the implementation of VBA and how much the orginal developers exposed of the application.  I am finalizing an application which also embeds VBA and we choose not to implement macro recording because of the difficultly.

Your best bet for learning more on this is to register for the free VBA SDK from Microsoft (see MSDN / Products / VBA)

Hope this helps....

- Steve
0
 

Author Comment

by:dannykrouk
ID: 2747200
Not the answer I was hoping for, but a good answer nonetheless.  Thanks.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now