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?
 
Back
Top