Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Merge from multiple files into new workbook in Excel 2007?
Hi, I had the following code working in Excel 2003 to read a hidden tab (SummaryMirror) with data and copy the data into one new workbook for all files within a specific directory. Sub MergeTrackers() Dim lastRow As Integer Dim docPath As String Dim baseCell As Excel.Range Dim...- rdhaan
- Thread
- Replies: 8
- Forum: Microsoft: Office
