run macro from another project

C

Chris

Hi,

I want to run a macro from normal.dot. The macro is located in another
project.

Have tried with application.run and call, but the public macro can not be
found.

When looking in the VBA - the project is called:
TemplateProject(FIH-kodebibliotek).
Under Modules the macro i located in the module 'Blandet'.
 
H

Heike Pertzel

Hallo Chris,

you need to make a reference on your project
TemplateProject(FIH-kodebibliotek). Than you can call your macro simply
with:
TemplateProject.Blandet

If you use other projects, you should give your project a better name.

Heike Pertzel / DATA 5 GmbH
 
H

Helmut Weber

Hi Chris,

there is a known bug. ;-)

Use something like this instead,

Application.Run "SystemwideUniqueModulename.Su­bName" or
Application.Run "SystemwideUniqueSubName".

Greetings from Bavaria, Germany

Helmut Weber, MVP, WordVBA


Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"
 

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

VBA word change keys 0
Consolidation Table from Different Excel Tabs with Different Format 1
Auto populate value from one task to another in MS PROJECT 0
Word macro that can call cells out of Excel for a find and replace 0
Run code from another workbook 7
Grouping Names in Mail Merge 0
Macro: VBA code to move/forward email based on subjects and attachments 0
How to call module function or sub from the Add In? 3

Top