Been a little frustrated trying to create a macro command to
accomplish what I need and was hoping for some insight.
I use SalesForce to manage leads. One of the lead sources provides
lead information via a static webpage, which I typically copy and
paste as text into Excel. it's formatted properly - standard questions
in column A, answers in column B.
In order to upload the lead into Sales Force I need to be able to
create a form in a browser and then submit to the following:
<form action="https://www.salesforce.com/servlet/servlet.WebToLead?
encoding=UTF-8" method="POST"

I've already created the form. My question is how do I create a custom
VBA that will push the information and correctly map each Answer in
Column B to the appropriate form field in html with one macro
activation?
I figure this could be done one of two ways:
can excel create and open its own html document with a macro?
If not, would i need to publish the blank form on my own website, and
excel can automatically upload the mapped
fields to the form with the push of a button/marco command?

Thank you,
frustrated