Hi,
I have the attached files, and I would like to extract data from one to another using advanced filter
Both Files
"Database" file is the closed one
"Report" file is the file that I would like to run the "UpdateDatabase" macro from
When I run the macro, it will get an error
Run-time error '1004':
Application-defined or object-defined error
When debug the error, the filter lines will be highlighted
What I need from this code is:
Any help will be highly appreciated
I have the attached files, and I would like to extract data from one to another using advanced filter
Both Files
"Database" file is the closed one
"Report" file is the file that I would like to run the "UpdateDatabase" macro from
When I run the macro, it will get an error
Run-time error '1004':
Application-defined or object-defined error
When debug the error, the filter lines will be highlighted
What I need from this code is:
- Check if "Database" file is currently open or not
- If not, get the required data and then close it
- If yes, get the required data only
Any help will be highly appreciated