LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Type Statements and Memory Release


I'd focus on trying to move those fixed arrays out of the base structure.
certainly the ones the size with CMS_MAX_USERS.

I've no idea of the raw data.. But max users is set on a 'global' level.
I'd assume it was a 'per server' setting.

If you have 1 1000 user server.. and 100 10 user servers...
you'd need to allocate m all for max_users e.g. 1000

Set the user_size into the type, and make the arrays of variable length.
e.g.

Type MyType
rows As Integer
cols As Integer
prop() As String
End Type

Sub ff()
Dim aTypes(40) As MyType

With aTypes(0)
.rows = 10
.cols = 2
ReDim .prop(.rows, .cols)
.prop(0, 0) = 1
.prop(0, 1) = 2
'etc
End With
'etc etc

End Sub



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(Neil Miller) wrote :

Thanks again keepITcool - that works great. At the risk of
"overstaying my welcome", I would appreciate you expanding on your
comment that you would not have defined a usertype in the way I
described. As I mentioned earlier in the initial Post, the INI files
get read and written using Get/Put and, to some extent, I am limited
by the datatypes allowed with these types of file.

Your thoughts would be appreciated if you have the time.

Thanks again.........Neil

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL 2007 - Out of Memory - memory leak/bug? PCLIVE Excel Discussion (Misc queries) 0 March 23rd 09 03:31 PM
Release Memory Jeff Excel Discussion (Misc queries) 1 September 25th 06 09:28 PM
Suggestions for the Next Release ExcelPro Excel Discussion (Misc queries) 0 May 24th 06 07:45 AM
Excel 12 New Release Bart Vwb Excel Discussion (Misc queries) 5 October 4th 05 10:07 PM
Release files from memory?? Ron[_21_] Excel Programming 3 March 5th 04 12:49 PM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"