With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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