| 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 |
| 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 | |||
Threaded Mode
