I'm trying solve a problem I have, but I can't find a solution anywhere.
I've got two workbooks.
One with my macros (workbook 1), and one that is generated each week, with different file names (workbook 2).
I've got a button in workbook 1 that's supposed to:
1. Let me select another file (workbook 2).
2. Open it, select the range "A2:W2" in it and create a autofilter.
3. Filter the 17th column to match the cell "Z19" in workbook 1.
I've tried numerous of different solutions from people with similar problems,
but I can't get it to work.
Here's what I got:
Sheet 5 in workbook 2 is named "Job list". That stays the same
even when the new file is generated. If that helps.
It opens a dialogue box, that let's me select a file, and opens it.
So far so good.
But the autofilter part is applied to workbook 1 instead of 2.
I know that the part with ws doesn't do anything. That is just left
from one of my alternative attemps.
I've tried with Windows. and Workbook. Activate, but with the same
result.
Bookmarks