VBA Code to Convert Excel Selection Range to HTML Table

This project was awarded to lsweb for $50 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

I need some VBA code that will take a selected range in MS Excel and will convert that range into an HTML table. I can't simply copy and paste the table because I want to get rid of all of the CSS that MS includes when you simply copy and paste a table.

So the code should convert the selection into an HTML table and dump that HTML to a text file or something.

There is a special requirement that the code needs to correctly color any cells that might have conditional formatting. The conditional formatting of the cells is very important.

The code must work on a selection range.

The resulting HTML table should be free of any other CSS or style tags, except for the cell color.

Feel free to let me know if you have any questions. I will pay $50 for this code.

I have attached a sample sheet that has a table to be converted.

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online