VBA: SaveSetting limitation?

[20 Ton Squirrel]

I need to store information about a workbook that is, potentially, 10KB to 20KB total in size. The data is structured in XML.

The SaveSetting function is quite tempting, but I'm unsure how much data I can store. Is there a limit on the string size?

I would rather avoid saving this to a local file, however, would that be more prudent?

 

[Juan Pablo González]

http://support.microsoft.com/kb/256986

Note There is a 64K limit for the total size of all values of a key.

 

[20 Ton Squirrel]

Fantastic! Thank you, the VBA documentation had no mention of it. I'll press on and see how it pans out.