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

 

[Greg Maxey]

This is a Word newsgroup. Did you consider posting your question in an
Excel group?

 

[ricowyder]

Sorry for invenience. Thanks Greg.

This is a Word newsgroup. Did you consider posting your question in an
Excel group?