How many files can I open in excel at one time, it seem 30 is the limit in
Excel 2003.

The answer to that question may be a function of the amount of memory
on your computer. If I may be so bold: why do you need 30 files open
at once? Perhaps if you'll explain your process we can suggest a
workaround that would not require so many open files.

Jim,

According to Excel 2002 help, "specifications and limits," the open
workbooks is "Limited by available memory and system resources." This is
also available for Excel 2000 at http://support.microsoft.com/kb/264626. So
two questions come up. Which operating system are you using, and how much
memory do you have? I just opened 40 workbooks in Excel 2002 with Windows
XP, 384 meg. Didn't try more.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"JIM.H." wrote in message
...
How many files can I open in excel at one time, it seem 30 is the limit in
Excel 2003.

Hello,
Thanks for the reply, I have a folder that has 52 excel file I open them all
and get certain fields form them and write to a single file.
So here is what I need to do then:
1. Loop through the files c:\Reports\*_YYYYMM_*_0_*.xls and copy their
contents to a single file and single sheet. Their contents are identical such
as A1=ID, B1=Name, C1=Amount
2. Sheet1 would have ID, Name, Amount at the end of the process above. Loop
though the Sheet1 and sum Amount per ID and create a new sheet Sheet2 that
has ID, Name, TotalAmount.

How can I do this?


"Dave O" wrote:

The answer to that question may be a function of the amount of memory
on your computer. If I may be so bold: why do you need 30 files open
at once? Perhaps if you'll explain your process we can suggest a
workaround that would not require so many open files.

Jim,

Dave has a point, and it may apply to your situation. Often separate
sheets, and even separate workbooks are used when combining the data in a
single workbook, or often, a single sheet, makes life much easier. Part of
this is covered in "Data across separate sheets" at
http://www.smokeylake.com/excel/excel_truths.htm.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dave O" wrote in message
oups.com...
The answer to that question may be a function of the amount of memory
on your computer. If I may be so bold: why do you need 30 files open
at once? Perhaps if you'll explain your process we can suggest a
workaround that would not require so many open files.

Thanks Earl, How would you realize that I mentioned in my previous message?



"Earl Kiosterud" wrote:

Jim,

Dave has a point, and it may apply to your situation. Often separate
sheets, and even separate workbooks are used when combining the data in a
single workbook, or often, a single sheet, makes life much easier. Part of
this is covered in "Data across separate sheets" at
http://www.smokeylake.com/excel/excel_truths.htm.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dave O" wrote in message
oups.com...
The answer to that question may be a function of the amount of memory
on your computer. If I may be so bold: why do you need 30 files open
at once? Perhaps if you'll explain your process we can suggest a
workaround that would not require so many open files.

Jim,

I don't understand your question.

Also I wanted to mention that when you have a lot of files open, holding
Shift as you click File gives you a "Close all" option.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"JIM.H." wrote in message
...
Thanks Earl, How would you realize that I mentioned in my previous
message?



"Earl Kiosterud" wrote:

Jim,

Dave has a point, and it may apply to your situation. Often separate
sheets, and even separate workbooks are used when combining the data in a
single workbook, or often, a single sheet, makes life much easier. Part
of
this is covered in "Data across separate sheets" at
http://www.smokeylake.com/excel/excel_truths.htm.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dave O" wrote in message
oups.com...
The answer to that question may be a function of the amount of memory
on your computer. If I may be so bold: why do you need 30 files open
at once? Perhaps if you'll explain your process we can suggest a
workaround that would not require so many open files.