Results 1 to 3 of 3

Thread: VBA: SaveSetting limitation?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2011
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA: SaveSetting limitation?

    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?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA: SaveSetting limitation?

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

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

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Aug 2011
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA: SaveSetting limitation?

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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •