Hello Everyone, hope someone can help
In an Excel workbook I have VBA code which copies various cell data from a "Summary" Worksheet on multiple workbooks which are filled in by multiple other users, the code opens, gets the data from the summary and closes each workbook in turn and cycles through all necessary workbooks until all are done, this code i have working as required, however, now we have added to the multiple workbooks which the users complete an input box which the user is required to add a character string which then selects the various worksheets to make visible (not summary). I have a character string which only opens the Summary sheet in place.
So my question is - what code can i add can to the original VBA code which when it cycles through and opens each individual file can automatically fill in the required string into the Input box and save me from manually typing it in every time it opens a new workbook.
thanks in advance
Mark
In an Excel workbook I have VBA code which copies various cell data from a "Summary" Worksheet on multiple workbooks which are filled in by multiple other users, the code opens, gets the data from the summary and closes each workbook in turn and cycles through all necessary workbooks until all are done, this code i have working as required, however, now we have added to the multiple workbooks which the users complete an input box which the user is required to add a character string which then selects the various worksheets to make visible (not summary). I have a character string which only opens the Summary sheet in place.
So my question is - what code can i add can to the original VBA code which when it cycles through and opens each individual file can automatically fill in the required string into the Input box and save me from manually typing it in every time it opens a new workbook.
thanks in advance
Mark