TheTallman
New Member
- Joined
- Jul 4, 2021
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi All, In my one of the project, I need to use jSON file in excel in following manner so that I can tie up its columns with excel data.
For example - In my workbook there is a TAB like this ..
I want that User should be able to choose a particular json file from browse button in excel
And that file should be highlighted here like in yellow
once he picks , particular json file should be load in sql table. In sql table, it will be stored like this ..
In excel, there is column which value matches with Label so excel through validate button should match each and every entry and put value from hidden column next to it like this ..
Kindly help me how I can do this through VBA/MACROS. Sample files are attached !
For example - In my workbook there is a TAB like this ..
I want that User should be able to choose a particular json file from browse button in excel
And that file should be highlighted here like in yellow
once he picks , particular json file should be load in sql table. In sql table, it will be stored like this ..
In excel, there is column which value matches with Label so excel through validate button should match each and every entry and put value from hidden column next to it like this ..
Kindly help me how I can do this through VBA/MACROS. Sample files are attached !