jsalisbury
New Member
- Joined
- Nov 6, 2013
- Messages
- 1
(This request was cross posted at OzGrid <http://www.ozgrid.com/forum/showthread.php?t=183930>. Through my searches I found many relevant responses to merging excel workbooks into a single sheet on MrExcel, and so I posted in this forum as well.)
I am trying to merge multiple Excel workbooks into one sheet. I have found several code examples, but my issue is that all of the workbooks I am trying to merge are encrypted with a different password. Is there a way to indicate in the macro which specific files I want to merge (all files are located within the same folder) and what their encryption passwords are? I only have about 15 - 20 workbooks I am trying to merge, so I don't have a problem copying/pasting the code and entering in each password into the macro.
All workbooks have the same headings row (Row 1) with the information in each sheet having the same information in the respective columns.
One other thing is I would like to copy the data from the only visible sheet in each workbook. However, each sheet is named something unique. If this is too much of a problem, I can rename them all to the same sheet name, but I would prefer to be able to keep them as unique names.
Any help would be greatly appreciated. TIA.
I am trying to merge multiple Excel workbooks into one sheet. I have found several code examples, but my issue is that all of the workbooks I am trying to merge are encrypted with a different password. Is there a way to indicate in the macro which specific files I want to merge (all files are located within the same folder) and what their encryption passwords are? I only have about 15 - 20 workbooks I am trying to merge, so I don't have a problem copying/pasting the code and entering in each password into the macro.
All workbooks have the same headings row (Row 1) with the information in each sheet having the same information in the respective columns.
One other thing is I would like to copy the data from the only visible sheet in each workbook. However, each sheet is named something unique. If this is too much of a problem, I can rename them all to the same sheet name, but I would prefer to be able to keep them as unique names.
Any help would be greatly appreciated. TIA.
