LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Nigel
 
Posts: n/a
Default Issuing macro in workbook from separate workbook

Hi,
Can a macro be issued from another macro in another workbook?
i have a macro which copies cell contents, opens another workbook and looks
in range for a matching number. i can get as far as using one macro to copy
the selection and open the workbook, and another macro to select the sheet
required, match the number and paste the contents. However, i cannot issue
the other workbook macro from my button. i need to be able to start the other
macro with a command or correct input to start it.
my thought was
[personal.xls]workcell ( but this doesn't work )

Kind Regards,

Nigel
 
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
macro to browse for workbook, pick up data and looping uriel78 Excel Worksheet Functions 1 March 10th 05 12:37 PM
Extract specific data into its own workbook via macro? Adrian B Excel Discussion (Misc queries) 2 February 24th 05 06:09 AM
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 10:12 PM
workbook macro help ditchy Excel Discussion (Misc queries) 2 December 27th 04 04:48 AM
workbook macro help ditchy Excel Discussion (Misc queries) 1 December 26th 04 09:54 AM


All times are GMT +1. The time now is 12:44 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"