Importing Partial Macros?

J

Jarod Chay

Hi,

I know I can use the following code to import the entire AutoKeys macro into
a database.

app.DoCmd.TransferDatabase(acImport, "Microsoft Access", SourceDB, acMacro,
"AutoKeys", "AutoKeys")

However, I don't want to import the entire Macro. I only want to import one
new AutoKey entry without touching any other existing entries.
Macro Name: {F9}
Action: RunCode
Function Name: =MsgBox("Hello World")

Is there any way to automate importing or creating one new Macro entry
without replacing the entire Macro object (and hence losing any existing
entries)? Ideally, I want to be able to search the existing entries as well
to see if the {F9} is already in use and ask the user to confirm an
overwrite.

Regards,

- Jarod Chay
Automated Design Systems
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top