orialmog / vba-json

Simple parser for json written in vba, types returned are collection/dictionary based. Automatically exported from code.google.com/p/vba-json
4 stars 0 forks source link

here's an update for office 64-bit support #13

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Try to compile and run in 64-bit excel, for example

What is the expected output? What do you see instead?
Attached screenshot shows the error message.

What version of the product are you using? On what operating system?
64-bit office, 64-bit windows 7

Please provide any additional information below.
The attached cStringBuilder.cls has the proper defines to work with 64-bit 
systems.  I couldn't figure out how to check it into svn here.

-joe

Original issue reported on code.google.com by jho...@gmail.com on 12 Jan 2011 at 7:37

Attachments:

GoogleCodeExporter commented 8 years ago
use this

#If Win64 Then
Private Declare PtrSafe Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" _
      (pDst As Any, pSrc As Any, ByVal ByteLen As Long)
#Else
Private Declare PtrSafe Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" _
      (pDst As Any, pSrc As Any, ByVal ByteLen As Long)
#End If

Original comment by myungdae...@soonjeonggame.com on 11 Mar 2014 at 4:01

GoogleCodeExporter commented 8 years ago
Hi I am trying to parse the below but I am getting an error that Object Not 
Found.
{"schedules":[{"summary":"Sign in","executedOn":"10/Oct/12 1:50 
PM","cycleName":"asdf","cycleID":15,"label":"1, 2, 3, 4, 
5","issueId":123,"versionName":"asdf","issueID":123,"defects":[{"key":"124","sta
tus":"Closed","summary":"Title"},{"key":"asdf","status":"Closed","summary":"asdf
asdf"}],"executedByDisplay":"Name of 
person","executionStatus":"2","htmlComment":"asdfasd","projectID":"asdf","execut
edBy":"asdasg","component":"","versionID":"adasd","issueKey":"asdf","scheduleID"
:73,"comment":"adsfasdf"},{"summary":"asdf","executedOn":"10/Oct/12 1:17 
PM","cycleName":"asdf","cycleID":15,"label":"1, 2, 3, 4, 5, 6, 7, 89, 5, 
34","issueId":10012,"versionName":"sdf","issueID":10012,"defects":[{"key":"asdf"
,"asdf":"asdf","summary":"asdf"},{"key":"asdf","status":"Closed","summary":"asdf
"}],"executedByDisplay":"asdf","executionStatus":"2","htmlComment":"asdf","proje
ctID":10002,"executedBy":"asdf","component":"","versionID":10001,"issueKey":"Edf
","scheduleID":18,"comment":"asdf"},{"summary":"asdf","executedOn":"10/Oct/12 
1:20 PM","cycleName":"asdf","cycleID":15,"label":"1, 
2","issueId":10011,"versionName":"asdf","issueID":10011,"defects":[{"key":"asdf"
,"status":"Closed","summary":"asdf"},{"key":"asdf","status":"Closed","summary":"
asdf - 
asdf"}],"executedByDisplay":"asdf","executionStatus":"2","htmlComment":"asdf","p
rojectID":10002,"executedBy":"asdf","component":"","versionID":10001,"issueKey":
"asdf","scheduleID":17,"comment":"asdf"},{"summary":"asdfasdf","executedOn":"10/
Oct/12 1:26 
PM","cycleName":"asdf","cycleID":15,"label":"1,2","issueId":10010,"versionName":
"asdf","issueID":10010,"defects":[{"key":"asdf","status":"Closed","summary":"asd
fa"},{"key":"asdf","status":"Closed","summary":"asdf"}],"executedByDisplay":"asd
fasf","executionStatus":"2","htmlComment":"asdfafd","projectID":10002,"executedB
y":"asdf","component":"","versionID":10001,"issueKey":"afgaf","scheduleID":16,"c
omment":"asdf"}]}

Original comment by sajja.pr...@gmail.com on 12 Jun 2014 at 9:22

GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
Sorry the actual error is Object Required see attached.

Original comment by sajja.pr...@gmail.com on 12 Jun 2014 at 9:25

Attachments:

GoogleCodeExporter commented 8 years ago
Hello,

I am getting the error "Run-time error '424': Object Required".

How to fix this?

Original comment by glsmca.c...@gmail.com on 27 Aug 2014 at 10:27

GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
i'm getting this error: type mismatch at this line: CopyMemory ByVal 
UnsignedAdd(StrPtr(m_sString), m_iPos), ByVal StrPtr(sThis), lLen
i added already the PtrSafe to the function decleration

Original comment by ohr.hach...@gmail.com on 12 Nov 2014 at 9:01

Attachments:

GoogleCodeExporter commented 8 years ago
use UnsignedAdd(CLng(StrPtr(m_sString)) instead of 
UnsignedAdd(StrPtr(m_sString).

Jorge Sequeira

Original comment by sequeira...@gmail.com on 23 Dec 2014 at 5:18

GoogleCodeExporter commented 8 years ago
I am getting the error "Run-time error '424': Object Required".

How to fix this?

Basically JSON.parse(jsonText) is returning null. How to fix this ?

Original comment by vikas.ba...@gmail.com on 5 Jan 2015 at 4:25

GoogleCodeExporter commented 8 years ago
Thanks to comment by #8
I could applied for my core application at 64Bit Flatform.

Original comment by supp...@linkhub.co.kr on 9 Jan 2015 at 8:31

GoogleCodeExporter commented 8 years ago
got an error while parsing a value that could not be cast to int cint(). 
Changed code to clng and resolved issue

Original comment by Daniel.T...@gmail.com on 28 Jun 2015 at 6:02

GoogleCodeExporter commented 8 years ago
thanks - this fixed an issue for me that only arose when i upgraded to windows 
10.

Original comment by james_...@jmatthews.org on 14 Aug 2015 at 4:50