VBA Question

[hemantmohan.1]

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. Help will be greatly appreciated.

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

 

[njimack]

Re: hi All.

Shouldn't that be Workbooks("Performance Sheet.xls").Activate? By the way, you don't need to activate or select the file or sheet...

With Workbooks("Performance Sheet.xls").Sheets("Performance Sheet")

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

End With

 

[hemantmohan.1]

Re: hi All.

Hey mack,

Appreciate the solution. I was trying to run this macro at home, however the path that ia given in the following macro is from my office's sharedrive.

I know that it will not work here but can you tell me a way or a macro that i can use in order to collate data from a file by just mentioning the date as it will change on a daily basis.

What i mean to say is i will just enter the date and run the macro and it should copy the data from that file and paste it in the file from where i am running the macro ?

 

[njimack]

Re: hi All.

Hey mack,

Appreciate the solution. I was trying to run this macro at home, however the path that ia given in the following macro is from my office's sharedrive.

I know that it will not work here but can you tell me a way or a macro that i can use in order to collate data from a file by just mentioning the date as it will change on a daily basis.

What i mean to say is i will just enter the date and run the macro and it should copy the data from that file and paste it in the file from where i am running the macro ?

Fairly simple to do but you need to provide specifics - file path, file name, ranges to be copied and where you want them copied to.

 

[hemantmohan.1]

Thanks.