Completed

Excel VBA script making HTML page

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]">

<head>

<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" />

</head><body>

5.5- Could the title tag also be dynamic? <title> ?TABNAME? </title> so this would be the name of the tab

Skills: Excel, Visual Basic, HTML

See more: python script read html page, excel vba script modify existing vba, vba save image html page, uploading excel file database searching html page, simple excel vba script, script populate html page, excel vba script find text, excel vba code data web page, excel vba extract data web page, excel vba code save web page, excel vba webbrowser autologin web page, script parse html page, excel vba script merge cells, perl script parse html page, bash script add html page, excel vba auto login web page, excel vba code converting html, upload excel live data feeds html page website, php script rip html page

About the Employer:
( 10 reviews ) Nashville, United States

Project ID: #21152244

Awarded to:

witoon1980

I already made the excel VBA code for generate your excel table sheets to html files. Could you kindly see inside my portfolio. https://www.freelancer.com/u/witoon1980?w=f I prepare both video and gif animation for you More

$10 USD in 1 day
(0 Reviews)
0.0

20 freelancers are bidding on average $41 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$30 USD in 7 days
(327 Reviews)
7.9
nagyzoltan68

Hello, I would like to work on your project. I have a great experience using excel macros / vba, html. I have had similar work before and I have attached below a link to a presentation file of my previous work, you ca More

$30 USD in 1 day
(121 Reviews)
6.4
expertatwork

I can update your VBA to create the HTML file. Please reply, thank you.

$50 USD in 1 day
(198 Reviews)
6.0
qprotex

Hello, My name is Miguel Febres and you can locate my resume and certifications in the following links: [login to view URL] [login to view URL] In my 10+ years of experien More

$50 USD in 1 day
(18 Reviews)
5.8
vlayausa

Hello, I am proficient with Excel and VBA. I would love to help with this project, it looks pretty simple to me. Please contact me for more information.

$30 USD in 1 day
(142 Reviews)
5.8
AndreiPPB

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.

$50 USD in 1 day
(6 Reviews)
4.5
finest2019

Dear client. I'm finest. The best quality and highest speed promsed. Here is a high skill data manager I've got a lot of expertises that will allow me achieving perfectly all the projects and assignments because my ski More

$30 USD in 2 days
(7 Reviews)
3.3
indrapandu

Hi, I am Excel VBA expert and have great experience to work around creating HTML page using VBA. I can quickly complete your HTML script. Let's have a a chat for detailed discussion. Looking forward to hearing from yo More

$25 USD in 1 day
(11 Reviews)
3.2
emilianoreyes70

Hi! Im ready to start, please ask for a preview/Demo file. Regards, Emiliano I am a engeneer and Excel/VBA/Macro expert. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic A More

$30 USD in 7 days
(2 Reviews)
2.9
samobot

"I have 10+ years of experience working with Microsoft Excel (+VBA Macros development), PowerPoint, Word. I am also very good at capturing data from internet and organizing it in a way which becomes very easy to retrie More

$15 USD in 2 days
(4 Reviews)
2.5
$301 USD in 1 day
(3 Reviews)
2.4
Bsram88

Hi, I am Full Time Freelancer, Currently i am concentrating on VBA in excel, access, VB.NET, C# 1. Do you have another job? If yes, are you planning on leaving? When will you be available? Yes currently Doing a VB.NET More

$15 USD in 1 day
(1 Review)
0.6
amerfpv

Hi, I can do these improvements in next few hours. I have more than 10 years experience dealing with excel challenges. Thanks Amer

$15 USD in 1 day
(1 Review)
0.6
goodwork20k

I am good in vba, powershell along with automation and development experience, please let me know if you are good to award this project to me

$30 USD in 3 days
(0 Reviews)
0.0
mido9696

get free sample i'm ready to work for you hello i'm interested in your project i have 10 years experience in this field I was Created many application with visual Basic , C# Programming and database please check my por More

$25 USD in 1 day
(0 Reviews)
0.0
yousrachamsy1999

Hello dear, I wish you are okay I`m willing to do a free test for you to assure my work quality . I`m available and i have what it takes to handle these kinds of projects. I have a decent experience in fromatting wo More

$20 USD in 7 days
(0 Reviews)
0.0
uchhalian

Greetings ! I have read your project description . I can different html files from different sheets from spreadsheets. Your data will be centered in the tables. Headings will be applied on first row and column respecti More

$20 USD in 1 day
(0 Reviews)
0.0
Varshini323

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.

$15 USD in 3 days
(0 Reviews)
0.0
irudyk

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.

$20 USD in 1 day
(0 Reviews)
0.0