ExcelBanter - Opening multiple files

ExcelBanter (https://www.excelbanter.com/)

- Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)

- - Opening multiple files (https://www.excelbanter.com/links-linking-excel/31831-opening-multiple-files.html)

Subhro Mukherjee via OfficeKB.com

Opening multiple files

I have 6 excel files which are to be opened in a sequence. Any help regarding
writing a macro to do that?

Bill Manville

Workbooks.Open ThisWorkbook.Path & "\FirstBook.xls"
Workbooks.Open ThisWorkbook.Path & "\SecondBook.xls"
etc.

Or you could save the set of 6 workbooks as a "Workspace" (xlw file)
and open that xlw file.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

All times are GMT +1. The time now is 07:59 PM.