Everytime i convert excel to json, I want to add some text before and after the json output file with below vba code, how can i achieve it ?
Eg. Add "var data = { "data": 1130,"id": " ..............and ..................."}"......before and after json file.
Please Login or Register to view this content.
Last edited by chhiew; 06-24-2019 at 07:30 PM.
It's not clear what you want to add at before/after/end but you should be able to do it here,
and here.Please Login or Register to view this content.
For example.Please Login or Register to view this content.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Hi Norie,
Thanks for enlightening me, you are right your suggestion is working but there is an extra "" , when i tried to remove them got this error "compile error, expected: end of statement", any idea how to fix this?
Output file now:
"var data = { "data": 1130,"id": "
What i want is below, without extra "":
var data = { "data": 1130,"id":
Thanks
Perhaps.
Please Login or Register to view this content.
Norie,
Yes your code is working perfectly, once again thank you so much, you are awesome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks