LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Macro in different books

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

Regards,
Tom Ogilvy

"VL" wrote in message
...
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!



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A macro code to print multiple sheets in different w.books Gladiator Excel Discussion (Misc queries) 3 February 22nd 10 07:49 PM
Macro 4 copy & paste between 2 books/files FARAZ QURESHI Excel Discussion (Misc queries) 1 October 7th 07 06:41 PM
Create a macro which can find a record in three books sand Excel Worksheet Functions 4 May 25th 07 04:18 AM
compare books macro bill Excel Programming 0 August 11th 03 03:36 AM
Put copy/paste between books in macro Rajat[_3_] Excel Programming 0 July 17th 03 06:00 PM


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"