VBA Code to export content of individual cells within a column
- or -
Post a project like this1408
£10(approx. $13)
- Posted:
- Proposals: 4
- Remote
- #2857636
- Awarded
Description
Experience Level: Entry
A very simple job that should take 10 mins.
I want to create a collection of JSON Files in a folder based on the content of individual cells in a column in excel.
So basically, I have a spreadsheet with a column starting with cell B12 to B26. Each cell contains a JSON script. I want a VBA that would export each of these cells into a separate .JSON format File and create a collection in a folder.
Note: Each cell contains a JSON Script.
http://excelerator.solutions/2017/08/24/convert-excel-to-json-using-vba/ suggest a way of converting/exporting to JSON but my job is actually easier as I have no variables. All I want is to have a VBA code, that would export contents of cells within a column to multiple JSON files in a folder.
I want to create a collection of JSON Files in a folder based on the content of individual cells in a column in excel.
So basically, I have a spreadsheet with a column starting with cell B12 to B26. Each cell contains a JSON script. I want a VBA that would export each of these cells into a separate .JSON format File and create a collection in a folder.
Note: Each cell contains a JSON Script.
http://excelerator.solutions/2017/08/24/convert-excel-to-json-using-vba/ suggest a way of converting/exporting to JSON but my job is actually easier as I have no variables. All I want is to have a VBA code, that would export contents of cells within a column to multiple JSON files in a folder.
Habib M.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
28 May 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Habib, I just wanted to comment that it should take 10 minutes only in your dreams :-) Not at all a practical time prediction for such an advanced type of coding. Keep in mind the chosen freelancer would only earn £8 from your budget, great if it really last 10 minutes, but it won't. Plus this is not an Entry level job. I would classify such job at Expert level.
922290
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies