How Can I call A Macro From One "Work book" to Another "Work book"?

[zameer_india]

Hi, All...

I would like to call a macro from one Workbook to another Workbook
What i Mean to say .. for example

Let I have To Workbooks , name workbook1 and Workbook2

In sheet1 of workbook1 i have data like

in the range A14
A B C D
X 2 3 4
Y 3 4 5
Z 4 5 6

I selected specific range mentioned above(A24) and selected th
columns graph

after that i deleted all the data , cut that graph and paste in anothe
"sheet2" , so that what ever the reflections/changes made by me in dat
range from the worksheet1 , occured in Graph of worksheet
successfully.

I recorded a Macro for the entire process.

I got a doubt , Now I want to add another workbook and paste the Grap
as similar process ... Could the Reflections occur same as in th
previous case(same workbook) if i change the data in sheet1 o
workbook1. If NOT then what is the Process to call a macro from On
Workbook to Antoher Workbook? Any help would be appreciated.

Thanx in advance,
Zameer Ahmed syed

 

[Bob Phillips]

To call a macro in another workbook, use

Application.Run "'workbook 1.xls'!myMacro"

--
HTH

Bob Phillips

"zameer_india" <[email protected]>
wrote in message
news:[email protected]...