Would like to create a button on a form to find an excel worksheet that has a matching product code and production date. The excel sheet may be in one of several workbooks in folders divided by month within yearly folder. Can anyone help? Thanks in advance. I am currently connecting the master folder from the form.
-
-
Within Excel you can run a search across multiple sheets if they are all selected already. In code you simply need to run the search against a collection of sheets - done by passing an array of sheet names to ActiveWorkbook. Worksheets().
Look in Application Automation for how to control an Excel session remotely (from Access for instance).
Comment