Hello. I’m new to VBA and I’m struggling to figure out how code to find a workbook on a network drive, then select only certain worksheets from within that workbook.
The overall goal is to open a new destination workbook, execute the command to navigate to the source workbook and individually select one or more of its worksheets, and then have it copy several cells (always the same) back to the destination workbook. I can open a file using a specific path, but I don’t know how to find a file that could be in one of several locations on our network. I also have not had any luck finding how to select only the worksheets I need.
Any help is greatly appreciated. Thanks.
The overall goal is to open a new destination workbook, execute the command to navigate to the source workbook and individually select one or more of its worksheets, and then have it copy several cells (always the same) back to the destination workbook. I can open a file using a specific path, but I don’t know how to find a file that could be in one of several locations on our network. I also have not had any luck finding how to select only the worksheets I need.
Any help is greatly appreciated. Thanks.
