hi All, please help me out.

[hemantmohan.1]

how can i create a macro that can open the excel file at the particular path and paste the data in another where i have set the macro button. What if there are 10 files that i need to do it from ?

 

[Weaver]

Might I recommend the excellent 'search' function of this forum!

A quick trawl revealed this, amongst others

http://www.mrexcel.com/forum/showthread.php?t=568192

 

[hemantmohan.1]

Thanks Weaver,

Can u help me with these codes. As soon as i run this macro it gives an error and stops at the line in bold

Public Sub CommandButton1_Click()

Dim d, m, y, od


Windows("Performance Sheet.xls").Activate
Sheets("Performance Sheet").Select

d = Range("A42").Value
od = Range("A46").Value
m = Range("A41").Value
y = Range("A43").Value

Application.ScreenUpdating = True

 

[hemantmohan.1]

what is run time error 9
subscript out of range

???