How much is too much in Custom Properties?

[VKY]

Hi,

I am trying to store some data into a custom property field
(Prop.Test.Value) and can't seem to find any information on the data
size limit. It seems that the limit depends on the amount of memory that
you have.

I have thus, created the function below to test how much data can be stored:

Public Sub Test(shpActive As Visio.Shape)
Dim Index As Long
Dim tStr As String

For Index = 1 To 32767
tStr = tStr & "A"
shpActive.Cells("Prop.Test.Value").FormulaU = """" & tStr & """"
Debug.Print Index
DoEvents
Next
Beep
End Sub

Almost everytime, the program tells me an "Out Of Memory" message when
the Index value is approximately 24000.

My questions to the people in the know, what is the
suggested/recommended limit one should adhere to when storing data on a
custom property field. How does Visio reacts to large amount of data,
slow down?

Thanks in advance.

 

[Mark Nelson [MS]]

Visio cells have a limit of approximately 64K characters.

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.