Macro in different books

V

VL

Hi,
this might be simple.
I would like to run a macro in one workbook that transfers
data between to other workbooks. My problem is that the
names of these two books gets recorded. Is there a way to
make the macro run using books having different names each
time?
Thanx!
 
P

Peter Atherton

Hello

Save the workbook as Start and this will open each time
you use Excel. Then the macro will be available to other
workbooks that are opened.

Regards
Peter
 
T

Tom Ogilvy

How would you communicate to the macro the names of the workbooks.

Regards,
Tom Ogilvy
 

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

Word VBA - Want to test if Full Name is NOT Present in document 0
Consolidation Table from Different Excel Tabs with Different Format 1
Run code from another workbook 7
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
VBA word change keys 0
Excel model - Very fast first time - Very slow second time 1
Working on birthday "book" for my wife and having layout/editing trouble 0

Top