CODEWITHSUNDEEP
htmlvbagoogle-mapsexcel
Just another programmer
Just another programmer

Reputation: 53

How to convert an excel cell into a HTML file?

I would like to ask for some help (again), here's my context : I'm trying to create an Excel Worksheet that I can add some coordinates and generate an html page with a map using Google Maps API and his markers.

I have successfully created a macro that get the data from my SQL Server and that also create the html structure (tags,header,body,etc.).

Here's my problem : There is a way to create a macro that get the value of my cell (that contains the HTML structure) and transform it into a HTML page? (Also, I have to be able to save this file into a directory, because it will be used by other users)

Thanks in advance!

Upvotes: 0

Views: 1863

Answers (1)

Jim
Jim

Reputation: 6881

Your question basically boils down to this... How do I read the value from a cell and save it to a text file? After all, an HTML file is just a text file with the .html file extension.

So, I assume you already know how to read the value of a cell. Now comes the question of how to write that string to a text file, and that part of the question has been answered before, both in MSDN articles that you can find via a Google search, and right here on SO...

https://stackoverflow.com/a/11503299/1246574

Hope this helps. Sometimes solving a seemingly complex problem is about breaking the question into simplified parts.

Upvotes: 1

Related Questions