VBA to run an Add-in?

[frankt68]

Hi!

I'd like to know whether it is possible to run the add-in using VBA code and if it is how can I do it?
:banghead:

 

[Pat Hartman]

What add-in are you talking about? And is it set up to be executed this way?

 

[frankt68]

What add-in are you talking about? And is it set up to be executed this way?

I got the add-in on the Helen Feddema's Home Page (code20.zip). This add-in allows you back up front end Access databases and the most common types of back end databases.
I must admit that I do not have much experience with Access, but I'm looking for possibility that users can more easily backup the database, for example, by clicking a button or even automatically when closing a file. I've googled for the answer, but I could not find anything suitable. DoCmd.RunCommand acCmdBackup command also does not do the expected backup. That's why I'm thinking about an option of creating a backup by clicking on the button (or automatically when closing a file) and runnig this add-in that would do a backup.
I have no idea whether this add-in is set up to be executed that way.

 

[Pat Hartman]

Addins are usually intended to be executed by mouse clicks through the GUI rather than code. If the addin is not protected, you can open it and view the code to see what you would need to do to execute it. It would probably be easier to just search for code to create a backup directly.