Thanks ahead of time for any insight.
As I'm learning more about VBA, I'm wondering can Macros search a specified file location, and from there query a specific excel file there? My plan is to automate a process where a daily macro will query a specific file location and open an excel file from that location. The macro ideally would be able to query the excel file to locate any blank cells and copy corresponding data from the row of the blank cell to another excel file.
Does anyone have any insight into accomplishing this?
As I'm learning more about VBA, I'm wondering can Macros search a specified file location, and from there query a specific excel file there? My plan is to automate a process where a daily macro will query a specific file location and open an excel file from that location. The macro ideally would be able to query the excel file to locate any blank cells and copy corresponding data from the row of the blank cell to another excel file.
Does anyone have any insight into accomplishing this?
