Phoenix - Your AI AssistantPPH092_001 Enable VBA-JSON to Parse a json file
- Posted:
- Proposals: 3
- Remote
- #1699548
- Awarded
have already sent a proposal. Description
Experience Level: Intermediate
PPH092_001 Enable VBA-JSON to Parse a json file
VBA-JSON is public VBA program available at https://github.com/VBA-tools/VBA-JSON/releases. The download includes a readme.txt file that explains ow to make it work. This job involves:
• Downloading and installing VBA-JSON (v2.2.3) on your machine (Windows 10)
• Creating an XLSM file to be called PPH091_004.xlsm which will act as a Shell for VBA-JSON
• PPH091_004.xlsm will act an interface between VBA-JSON and the attached json file: PPH092_003.json
• Incorporating VBA-JSON into PPH091_004.xlsm including any copyright notices
• Making amendments to VBSA-JSON code to connect it to the json input file.
• Output from executing PPH091_004.xlsm should be to a worksheet called “vbajson”, not debug.print
This is suitable for any competent VBA developer especially one who knows about processing json strings in VBA.
The job should be completed within 4 days of commissioning and is completed when PPH091_004.xlsm is delivered.
VBA-JSON is public VBA program available at https://github.com/VBA-tools/VBA-JSON/releases. The download includes a readme.txt file that explains ow to make it work. This job involves:
• Downloading and installing VBA-JSON (v2.2.3) on your machine (Windows 10)
• Creating an XLSM file to be called PPH091_004.xlsm which will act as a Shell for VBA-JSON
• PPH091_004.xlsm will act an interface between VBA-JSON and the attached json file: PPH092_003.json
• Incorporating VBA-JSON into PPH091_004.xlsm including any copyright notices
• Making amendments to VBSA-JSON code to connect it to the json input file.
• Output from executing PPH091_004.xlsm should be to a worksheet called “vbajson”, not debug.print
This is suitable for any competent VBA developer especially one who knows about processing json strings in VBA.
The job should be completed within 4 days of commissioning and is completed when PPH091_004.xlsm is delivered.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Geoffrey,
I have been looking at this with a view to submitting a proposal but I was wondering if you have a specification of the JSON layout and what you are trying to extract. It contains nested values and arrays and it is not going to fit straight into a worksheet.
Kind regards,
Simon C.