Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Multiple Workbooks or Worksheets
Question, is it better to open mulitple workbooks or have one workboo
with multiple worksheets. I will be doing a lot of computation wit these files/sheets in VBA, and I was wondering which would be mor efficient. If "multiple worksheets" is the answer, then how do I get the info fro the other workbooks to the multiple-sheet workbook? The only way I ca think of is writing a macro to copy and paste the info onto a ne worksheet. Is that the only way? I hope I am making sense. Joh -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
open multiple workbooks at startup | Excel Discussion (Misc queries) | |||
VBA code for looping through open workbooks and worksheets | Excel Programming |