Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Quick vba macro to create an html file based on content in an excel cell
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.


Job awarded.

Feb 28, 2012

Job Description

  |  Change History >>


  • Posted: Tue, Feb 28, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

Hi there,

I need a macro in the attached excel file that does the following:

1) Create an html file that has the script of F2 in it and nothing else
2) Name this html file by the contents in G2
3) Do this for every row until it hits a blank cell in column F (i.e., create a loop that stops when G is blank)

So, for example, the macro would create 2 files with the current data: one with the script in F2 that would be called "WWD_Thurmond.html" and one with the script in F3 that would be called "FW_Bailey.html". If the spreadsheet had 3 more rows, it would create 5 total files, etc.

It would be great if you could have a pop up box that asks the user to specify the file path that these files should be saved in. Alternatively, it would be fine to have the files be saved in the same file path as the current excel file that is being used.

Thanks for the help and looking forward to working with somebody!


Sign in or Register to see more

Desired Skills
Job ID: 28963762
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Serbia  |  
My main job is VB\VBA programing. I have done hundreds of Word macros, many Excel macros, as well as Project and Publisher projects. I have also...
 0.0   |  Private   |  1 Jobs
Bid ID: 28964019  |  Submitted: Feb 28, 2012 22:26 ET 
Proposal SEALED

High quality service at most reasonable cost. Elance Test : Microsoft Excel- Top 1%, Microsoft Word- Top 5%, MS Office - Top 10%. Developed...
 5.0   |  Private   |  6 Jobs
Bid ID: 28963918  |  Submitted: Feb 28, 2012 22:19 ET 
Within 1 day

 China  |  
Service Provided: Customization of Office Macro and Templates with VBA; Desktop Application Development with VB.Net, VB6 & VC++; Check below...
 0.0   |  Private   |  0 Jobs
Bid ID: 28963910  |  Submitted: Feb 28, 2012 22:18 ET 
Proposal SEALED

Christine Leisner      
Christine Leisner's identity has been verified.  Learn More
 United States  |  
Over the last 20 years, I have developed numerous Microsoft Office tools using formulas, functions, macros, VBA, Pivot Tables/Charts, and User...
 4.9   |  Private   |  23 Jobs
Bid ID: 28963897  |  Submitted: Feb 28, 2012 22:17 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »