I have the beginnings of a VBA for Excel script that will create an HTML file. I need the following improvements:
1 - Dynamically read each tab to set parameters.
2 - Create one html file for each tab in the spreadsheet. Name the html file the same as the tab name. Example sheet1 would be sheet1.html.
3 - I would like the data in all cells centered in the html table cells
4 - First row and first column should be both centered and bold in the html file
5 - Finally correct this code (resBeg = "<html><head></head><body><table>") to include this html: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[login to view URL]">
<html xmlns="[login to view URL]">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title> ?TABNAME? </title>
<link href="2014-FitCharts/[login to view URL]" rel="stylesheet" type="text/css" />
5.5- Could the title tag also be dynamic? <title> ?TABNAME? </title> so this would be the name of the tab
20 freelancers are bidding on average $41 for this job
Hello. I read your requirement carefully. I'm very interested your project. I have many experience in VBA. If you assign to me this project, you can get a cool result. please contact me. thanks. best requards.
My experience in IT industry is more than 12+ years. In my professional life, I have done lot of macros and I am really good at that. Also I am ready to provide support for a week after the work is done.
I've reviewed your files and instructions. With over 25 years of experience in VBA coding in Excel, I'm confident that I can update your existing code to your specifications. Thank you for your consideration.