markusbecom
New Member
- Joined
- Sep 17, 2020
- Messages
- 1
- Office Version
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
hello all,
I am new to VBA and would like to post a question for using VBA macro to read csv file and save the data into two XML and JSON format files and both of which represent source data in a hierarchical object-orientated fashion.
CSV file example:
Can anyone help on this?
Thank you!
I am new to VBA and would like to post a question for using VBA macro to read csv file and save the data into two XML and JSON format files and both of which represent source data in a hierarchical object-orientated fashion.
CSV file example:
CATEGORY | SUBCATEGORY | ITEM | NOTES |
Food | Bread | Large white loaves | sliced and unsliced |
Food | Bread | Large wholemeal loaf | |
Food | Bread | Bread rolls | |
Food | Bread | Garlic bread | |
Food | Cereals | Flour | |
Food | Cereals | Past |
Can anyone help on this?
Thank you!