Aebleskivers
November 4th, 2009 | 
Author: Aebleskivers!
Where have you been all my life?
Aebleskivers with powdered sugar.
Got this recipe from a lady who came in to make copies. I couldn’t resist.
MMMMMMMMMM……….
Posted in 
Tags: 
Posting Excel Data To A Web Form
For some reason you are collecting information in Excel that you wish to post to a web form. This may be an internal office application you use for sales information or parts tracking , etc. Whatever it is, you need to post it to a web form for processing of sime kind. Either adding to a database or placing a company order.
VBA allows a relatively easy way to post your Excel data to a web form.
First, we need to know the structure of the form. Let’s imagine our form looks something like this…
<form method=”post” action=”" name=”form1″ id=”form1″>
<input name=”first_name” type=”text” id=”first_name”/>
<input name=”last_name” type=”text” id=”last_name”/>
<input name=”Submit” type=”submit” value=”submit” id=”submit”/>
</form>
Now we have a form structure we can work with. We can now create the VBA routine to post the data.
Using array_keys() and variable variables to assign posted data to variables in PHP.
Yes, you read it right. Variable variables is a feature in PHP which allows us to assign a variable based on the value of another variable.
The PHP manual explains it with the example below: