VBA字符串255个字符限制(VBA string 255 character limitation)

VBA字符串255个字符限制(VBA string 255 character limitation)

我正面临与VBA一起工作的问题，并指出它有一个字符串限制为255个字符。 我实际上是尝试通过POST发送JSON并暂停执行我注意到该字符串总是只有255个字符。

有没有办法调整字符串或其他东西？

I'm facing issues working with VBA and noting that it has a string limitation to 255 characters. I'm actually trying to send a JSON through POST and pausing the execution I note that the string has always just 255 characters.

Is there a way to resize the string or something?

最满意答案

我浪费了大约6个小时来解决这个问题，最后检查它只是一个调试器限制 。 VBA调试器只显示字符串的255个字符，但这并不意味着它只包含他正在显示的内容。

当事情变得疯狂时我注意到了这一点，当我使用带有Len的MsgBox检查字符串大小和内容时，它就浮出水面。

希望它有所帮助，因为我读了很多人要求这个，但没有人告诉它。

I wasted around 6 hours into this problem to finally check that it was just a DEBUGGER LIMITATION . The VBA debugger just shows 255 characters of the string, but it doesn't mean that it contains just what he's showing.

I noticed about this when things were getting crazy and it went to the surface when I used a MsgBox with a Len to check the string size and content.

Hope it helps, because I read lots of people asking for this but nobody told about it.