invoking an add-in from a macro?

  • Thread starter Thread starter JurgenBrea
  • Start date Start date
J

JurgenBrea

I would like to record a macro which highlights some cells, then runs an
add-in. The add-in takes the highlighted cells and exports them to a new
file. However when I record the macro, it does not record the add-in step,
it only records me highlighting the cells. Is it even possible for a macro
to invoke an add-in?
 
Yes it is. You need to link to the add-in in the VBE (Tools>References),
and then click the add-in.

You can then call any routines in the add-in by name.
 
hmm... well I tried that. went to tools/references from the VB editor.
Then browsed for the xla. It freaked out and said it could not do it as it
had the same name as something else.... I know I should have put the message
in here but it's on my work computer and I'm at home now. Any thoughts?
 
You must log in or register to reply here.

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

Similar Threads

Macros behave differnet when invoked by different methods 2
Moving a bunch of data 1
Macro to add Multiple rows in same sheet 1
Text to Columns macro 1
Restrict Use of a macro 3
Pasting cell contents into a macro 1
code to dis[play a message if the active cell contains an asteric 2
Excel Staff Grade and Shift 0

Back
Top