Hi,
I am trying to pull data from a closed workbook using advanced filter.
here is what my code looks like right now. It works fine if I have both the workbook with the criteria as well as the workbook "ORDERS CHART" open
However, if "ORDERS CHART" is closed, I get the following error:Please Login or Register to view this content.
Any help would be greatly appreciated! I have been stuck for days!Run-time error '1004':
Method 'Range' of object'_Global' failed
Bookmarks