Max string length of Shape.Fill.UserPicture(PictureImage as String)?

I've searched MSDN and elsewhere, but to no avail.

Does anyone know the exact maximum string length allowed, referenced as "sURL" in the snippet below?

Please Login or Register  to view this content.

So far, I get an (Error 5) when LEN(sURL) = 1066, but do not get error when LEN(sURL) = 340.

Thanks,

-ds-

Hello AlvaroSiza,

Based on the internal path length for API Unicode strings, I would say 520 characters.

Thanks Leith.

There is documentation to indicate theoretical limits for strings at 2 GB (2^31 chars, or ~2 billion chars). That said, some of the built in functions have much smaller limits (such as msgbox = 1024, etc.). It would appear that Shape.Fill.UserPicture would have a cap in place as well.

I'm essentially building a URL string in an array and passing that to the Google Static Maps (v2) API, which then renders in an msoShapeRectangle. To expand, is there another approach I am not considering to get around the apparent limitations?