Thread
:
Open Multiple Workbooks or Worksheets
View Single Post
#
2
Posted to microsoft.public.excel.programming
mark E. Philpot
external usenet poster
Posts: 3
Open Multiple Workbooks or Worksheets
Hi,
It depends on the size of data for each sheet.
If one workbook is over 10mb then, yes, separate
workbooks is better. If the total of all sheets is less
than 10mb then one workbook is easierto handle.
If you think that the way you are doing things now is too
cumbersome then maybe a userform may be the answer. Send a
dummy workbook (about 1mb) to me and I will evaluate it.
Anything I do is free until I say not.
see some of my sample works at:
http://au.geocities.com/excelmarksway
http://www.geocities.com/excelmarksway
regards
Mark E. Philpot
-----Original Message-----
Question, is it better to open mulitple workbooks or have
one workbook
with multiple worksheets. I will be doing a lot of
computation with
these files/sheets in VBA, and I was wondering which
would be more
efficient.
If "multiple worksheets" is the answer, then how do I get
the info from
the other workbooks to the multiple-sheet workbook? The
only way I can
think of is writing a macro to copy and paste the info
onto a new
worksheet. Is that the only way?
I hope I am making sense.
John
---
Message posted from
http://www.ExcelForum.com/
.
Reply With Quote
mark E. Philpot
View Public Profile
Find all posts by mark E. Philpot