run vba code dynamically of another add-in workbook

  • Thread starter Thread starter ilyaskazi
  • Start date Start date
Another workbook

Application.Run "book2.xls!test_msgbox"

with spaces in name

Application.Run "'another book2.xls'!test_msgbox"

.... with parameters

Application.Run "book2.xls!test_msgbox", 4, 8


An add-in is just a workbook, so replace xxls with xla

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Pulling data from one workbook to another one using VBA 0
Trouble Installing Excel VBA Code Cleaner into Office 365 0
read xml method-- faster one 1
Indirect reference to run macro in another workbook? 2
vba code does not run 3
add customui ribbon tab to a existing workbook 3
Macro that will insert a simple text string in top cell of text file 1
Run code from another workbook 7

Back
Top