getting compile error on 64-bit

[dineshgh]

I am using this in MS-Outlook 2010 (newbie VBA), trying to execute the example test code. A whole lot of functions are highlighted and I am not sure what fix I need to apply. Will greatly appreciate help. Thanks.

[timhall]

@dineshgh thanks for bringing this up. Looks like the Win64 compiler directive needs to come first since Win32 applies to both 32- and 64-bit Windows versions so the 64-bit part is never reached. I'll fix this shortly.

[dineshgh]

@timhall awesome, thanks.

[timhall]

@dineshgh Do you mind giving the following a try to see if it resolves the compilation error? (I don't have a 64-bit version to test against at the moment)

https://raw.githubusercontent.com/VBA-tools/VBA-JSON/compile-error/JsonConverter.bas

[dineshgh]

Tim, Thanks. I imported the new JsonConverter.bas as a module, and then
created a test function with the sample code. I get a different error now:

Error box: Compile error: User-defined type not defined

Highlighted Line: Private Function json_ParseObject(json_String As String,
ByRef json_Index As Long, Optional json_ConvertLargeNumbersToString As
Boolean = True) As Dictionary

I think I am missing type "Dictionary". Could I be missing some other type
library?

Regards, Dinesh

On Sat, Feb 21, 2015 at 7:31 AM, Tim Hall notifications@github.com wrote:

@dineshgh https://github.com/dineshgh Do you mind giving the following
a try to see if it resolves the compilation error? (I don't have a 64-bit
version to test against at the moment)

https://raw.githubusercontent.com/VBA-tools/VBA-JSON/compile-error/JsonConverter.bas

—
Reply to this email directly or view it on GitHub
#11 (comment).

[timhall]

Thanks for trying that for me, I think it would hit the 64-bit issues first so this should be fixed. To resolve the Dictionary issue, add the following to your workbook: https://raw.githubusercontent.com/VBA-tools/VBA-Dictionary/master/Dictionary.cls

[dineshgh]

Hi Tim, thanks for working with me. I don't really understand much of VBA
:( this is my first foray.

(My project: is to analyze and display an email out of AWS Cloud Config
emails. It's one big messy JSON blob.)

I imported the Dictionary class file, had to comment out the first 10 lines
because of syntax errors (VERSION through Attribute lines). Also btw there
is a typo in the test code for Dictionary (CompareMethod s should have been
singular).
Then I am trying to run the rest of the test code but keep hitting errors
like "Object doesn't support this property or method". It could be because
of the lines I commented out, maybe. So IOW I am still lost...

Regards
Dinesh

[image: Inline image 1]

On Mon, Feb 23, 2015 at 7:37 AM, Tim Hall notifications@github.com wrote:

Thanks for trying that for me, I think it would hit the 64-bit issues
first so this should be fixed. To resolve the Dictionary issue, add the
following to your workbook:
https://raw.githubusercontent.com/VBA-tools/VBA-Dictionary/master/Dictionary.cls

—
Reply to this email directly or view it on GitHub
#11 (comment).

[timhall]

You can download the test file directly here: https://github.com/VBA-tools/VBA-JSON/blob/compile-error/specs/VBA-JSON%20-%20Specs.xlsm

Where do you see the typo in Dictionary?

Those errors are probably from not importing properly, which can be a little tricky. I would recommend saving the files to JsonConverter.bas and Dictionary.cls, respectively, and then importing to Excel rather than creating empty classes/modules in Excel and pasting in. The header lines are only interpreted properly if you import the file. (For now I'd use the test file given above)

[dineshgh]

Hi Tim, the typo is in the dictionary TEST file.

I will try what you suggested. I am using MS Outlook - should be similar to
Excel VBA I hope.

Regards
Dinesh

On Tue, Feb 24, 2015 at 8:44 AM, Tim Hall notifications@github.com wrote:

You can download the test file directly here:
https://github.com/VBA-tools/VBA-JSON/blob/compile-error/specs/VBA-JSON%20-%20Specs.xlsm

Where do you see the typo in Dictionary?

Those errors are probably from not importing properly, which can be a
little tricky. I would recommend saving the files to JsonConverter.bas and
Dictionary.cls, respectively, and then importing to Excel rather than
creating empty classes/modules in Excel and pasting in. The header lines
are only interpreted properly if you import the file. (For now I'd use the
test file given above)

—
Reply to this email directly or view it on GitHub
#11 (comment).