I need to write an Excel macro which will convert the excel workbook into a JSON file. The excel will have multiple sheets, each sheet will have a tabular form of data (in rows and columns). One of the column will have hyperlinked data and the macro should extract and explicitly list the hyperlink as well.
Software/Hardware used: Microsoft Technologies | VB
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!