file path in input range of filter

[ricowyder]

Dear programmers,

A short question. I have a filter in my excel file, which gets data
from Worksheet "Data1" and shows the filtered data in Worksheet
"Event1".


Set InputRange(1) = Worksheets("Data1").Range("A1:H500")
Set OutPutRange(1) = Worksheets("Event1").Range("A1:H1")


I would actually prefer if those data from Worksheet Data1 would be
directly gotten from another file. Now, I am only copying in the
worksheets from one file to the other.


Do I have to define a String?
Or can I directly write it in the above-shown line?


Thanks for your help.


Regards,


Rico

 

[Tom Ogilvy]

Just an added comment. The other file must be open .

 

[Tom Ogilvy]

Set InputRange(1) =
Workbooks("Otherbook.xls").Worksheets("Data1").Range("A1:H500")
Set OutPutRange(1) = Worksheets("Event1").Range("A1:H1")