I Wanta Infopath Form To Submit Data To An Excel Databse File

Free Excel Help Forum

- Ask any question about Excel and have it answered in no time.

Similar Excel Tutorials

Input Form to Get Data and Store it in Another Tab in Excel
How to make a user input form in Excel and have the data stored on another worksheet at the click of a button. This ...
Use a Form to Enter Data into a Table in Excel
You can enter data into a table in Excel using a form; here I'll show you how to do that. This is a great feature ...
Vlookup Partial Match in Excel
Return Vlookup results on partial matches of a cell's contents. You could type the start, end, or middle of a looku ...
Do Something Every so Many Rows with a Macro in Excel
How to have a macro do something on a set interval of rows; for instance, input a value every 5 rows. Sections: The ...

Helpful Excel Macros

Open a PowerPoint Presentation from Excel
- This free macro for Microsoft Excel allows you to open any PowerPoint presentation from excel. You can change the file
Prevent Saving a Workbook under a Different File Name
- This Excel macro prevents the user from saving an excel file or workbook under a different file name. The file can only
Filter Data to Show the Bottom X Percent of the Data Set in Excel - AutoFilter
- This free Excel macro filters data to display the bottom X percent of the data set in Excel. This is a great macro to u
Open any Program from Excel
- This free excel macro allows you to open any program on your computer from excel. You can open a media player, file vie
Open Microsoft PowerPoint from Excel
- This free macro will open the Microsoft PowerPoint program on your computer. You do need to have this program first. T

Similar Topics

Is it possible using excel vba to open a xml file in notepad and do a find and replace, and then resave it?

Reason for asking is I am trying to reproduce an infopath form with data from excel, exported into an xml. Issue I have is when I export the xml from Excel, the header is not my infopath header so the xml is not recognized as an info path form. If you do a find and replace in the xml, infopath recognizes the form just fine...


Is it possible to import\export data to and from Infopath.
i know i can export Infopath forms into Excel but can i export an Excel spreadsheet into Infopath. I presume if this were possible i would have to have similiar fields in infopath to that in excel for the data i want to export.

i will need to be able to do this via a macro

basicly i will be export data from an application into Excel then export to infopath to display on our intranet site via sharepoint 2007, but it all has to work in 2003 versions as this is what the users have.

Thank you


I'm working in Excel and have done something in Visual Basic so that when a change or something is entered in a particular column I want an InfoPath Form to open.

It there a method similar to the

Workbooks.Open (Filepath name) that would work for an InfoPath form, I can get this to work to open an existing Excel spreadsheet, but not to open an InfoPath form.

The other way I was trying to achieve the same result was by having a hyperlink to the InfoPath form in my spreadsheet and then creating a macro to access the Hyperlink and then in the vb script having "Call Macro1"

This worked if I used INSERT - HYPERLINK and browsed to the InfoPath form which results in a link like:

But if I used INSERT - FUNCTION - HYPERLINK so I could have the full filename path like:
\\troy\org\timesheets current\annualleave.xsn

And I need it to use the second option (with the full filename path) as the timesheet / spreadsheet could sit in a number of various file locations.

Hope this doesn't sound too confusing.

Any help would be greatly appreciated.



I'd like to find a way to automate looping through a folder and converting all InfoPath forms into Excel spreadsheets. There's a reference to InfoPath in Excel, so I am thinking there has to be some way to automate this, but I can't figure out how to open a form and export it to Excel.

Anyone else try to take on this task?


Is it possible to link Infopath forms to Excel? Could anybody point me in the right direction if this is possible?

Many thanks in advance


I have a list of forms on WSS that I have exported to Excel. At this point I
can click on the "form name" and it opens my infopath form - this is good.
But when I create a pivot table and display the "form name" it is no longer
an active hyperlink. Ideally I need my users to be able to open the form from
the pivot table.

Is this possible?



Plese guide me how to go about this. My requirement is as follows.

I have to fill Web Form , same Form many times but with different data. This data is already there in my excel data base. Presently I am just copying and pasting field by field. But this is tedious. I can pull this data in 'Excel User Form'. Now what I want is as I press command button on my 'Excel User Form' say 'Submit to Web site' , internet explorer should get opened, site accessed and data in 'User Form' gets transferred to Web Form.

I have observed web site / URL doen't support GET function of HTTP because I tried free AutoFillWebForm Softwares which failed due to this error.

Plese help.


I have a textbox that allows the user to input their initials called "tbxinitialize." When the userform opens, the textbox is empty, the user fills in around multiple textbox's and combobox's and then clicks a Submit button. The form then unloads and then reopens.

I need the form to store the value of tbxinitialize from the first time they submit and then reload that value each time after they submit. How can I achieve this?

Thanks in advance!

I have a CSV file which contains employee data. There are 8 colums and 120 rows. I only need to copy the values from 4 of the columns (FirstName, LastName, EmployeeID and PhoneNumber) into a web form (text boxes) which holds 10 employees. How can I copy 10 rows of data to the web form and submit it and then do the next 10, etc using VBA.

Looking for advanced help with Excel/VBA. I am creating a catering form that a user will fill out and submit. There are three different sheets in the workbook and the user may only need to fill out 1 or 2 of the sheets at a time. On each worksheet, there is a submit button (that through VBA) sends the completed form to an email address.

In each worksheet, there are mandatory fields. I want to ensure all fields in the specific sheet are filled before hitting the submit button but I am unsure how to code the "once they hit submit, ensure these fields are filled out"

I can do it so that it prompts to fill in the fields before saving or closing the excel document, but I cannot figure out the "beforesubmit" option.

Any ideas? I can provide the document and code if need be

I am currently using the following code to open an Internet Explorer window, so that I can fill out and submit an online form.

Dim IE As InternetExplorer
Set IE = New InternetExplorer

With IE
.Visible = True
.Navigate "URL"
End With

However, when I go to the page in question a pop-up window appears. I therefore need to be able to close the pop-up window, or make the original (parent) window active, before I can submit the form. Does anyone know how I can do this?

Any help much appreciated - Thanks

Hi Mr Excel

I’m doing a school project that requires quite some VBA programming. I understand you’re quite the expert on this. Could you teach me a thing or 2?

I need to do an inventory management prototype with VBA forms. Basically I have 3 forms. Pre inventory check before sales, sales and post sales inventory check. I know how to create the form but am not sure how to make the information load into a data base and update along the way.

Form 1 (4 controls)
Select item
Count number of items in inventory
hit submit
close button

Form 2 (7 controls)
select item
Label that shows the number of item selected left in stock
Label that shows price of item
Input for number of items to sell
Total price
Submit button
Close button

Note: Form should immediately update point 2 - label that shows the number of items left in stock

Form 3 (5 controls)
Select item
Count number of items in inventory
hit submit
close button
Label that shows discrepancies (e.g. missing stock after counting when sales from form 2 is less than difference of form1 and form2 count)

I uploaded the excel workbook below

Is it possible to, and if so, how does one use excel to fill out a form on an existing web page? Based on the result of some formulas on my Excel work sheet, I am hoping to automatically fill out a few fields and submit an existing website form that I use a lot. Is there any way for Excel to communicate with a web form? Thank you for help on this.

I posted this on an earlier thread, but was urged to start a new one.

I'm trying to create a program that will automatically log in to a website that requires a username & password. I am able to enter the username and password in the correct text boxes, but I can not get the form to submit to approve the login. It refreshes and removes the password.

I have attached my code. The web url is inside it. Thanks!


Sub IE_login()
    Dim ie As InternetExplorer
    Dim C
    Dim ULogin As Boolean, ieForm
    Dim MyPass As String, MyLogin As String
    Set ie = New InternetExplorer
    ie.Visible = True
    ie.Navigate "https://applications.dacgroup.com/login.aspx"
    'Loop until ie page is fully loaded
    Do Until ie.ReadyState = READYSTATE_COMPLETE
    'Look for password Form by finding test "Password"
    For Each ieForm In ie.Document.forms
            ieForm(5).Value = "****"
            ieForm(6).Value = "****"
            Exit For
    End Sub

Hi all, a tough one I'm struggling with, for a kind soul Excel VBA guru if there is one reading!

I'm using WinHttp to access from Excel VBA an URL, say "http://server/application?id=abc".

When I open this URL from Explorer, I get an HTML table with lots of info. The idea is to parse the table contents and fill some cells in my spreadsheet with the values received.

However when I try from Excel VBA with code like this:

Dim ht As New WinHttp.WinHttpRequest
ht.Open "POST", "http://server/application?id=abc", False
ht.SetRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"
ht.SetRequestHeader "Content-Type", "multipart/form-data; "

I obtain the following ht.ResponseText:

[script language="javascript" type="">
function submitForm() {
[body bgcolor="#FFFFFF" ******="submitForm()">
[font size="20" color="blue">Loading. Please wait.
[form NAME="form1" ACTION="dispatch" METHOD="post">
[INPUT TYPE="hidden" name="action" value="response">
[INPUT TYPE="hidden" name="user_id" value="user">

So it looks like it sets a couple of hidden parameters on a form and then submits itself upon load.

I've tried various things to no avail, for example adding those hidden fields like this:

Dim login As String
login = "action=response&user_id=user"
ht.Send login

But it doesn't do what I want it to do, which is to submit the form and present the response.

So my question is: How can I construct the WinHttp send request so that I obtain the response from the submitted form, and not the form itself?

My brain is hurting now so if anyone has any pointers on how to do this, it'll be most appreciated! Thanks in advance.


I'm new to the forum and have very limited VBA knowledge. I would like to seek your help and guidance to create an excel request and approval form via e-mail.

I created a project cost file to keep track of cost estimates for individual project.
Each tab represent an individual project e.g. 001, 002 etc.and the total project cost is summed up in Summary tab.

The process as follows:
1) The Project Manager keeps a file with all project approval forms
2) The Project Manager will complete the project approval form and submit only the sheet by e-mail to GM for approval, copy the Accountant.
3) The GM will reply to Project Manager whether the request is approved or rejected, copy the Accountant.
4) The Accountant uses the e-mail as the supporting document in processing vendor invoices.

I referred to a previous thread http://www.excelforum.com/excel-prog...m-excel-2.html but only managed to partially construct the required form.

Attached my draft Project Approval file for your easy reference.

Many thanks for your assistance and guidance.

Regards, Tokkwang

I want to create a submit button that when I click on it, the current
worksheet/file will be e-mailed to someone. Instead of saving the
file, then inserting into an e-mail. I have seen this before in a
file before, but can't figure out exactly how it works. I happened to
notice in the VB Editor I saw something like...

Excel.Application.Send "myname@email.com"
End Sub

Or something similar to that. I don't know any VBA.. So if that's
what I need to learn, then let me know.


Dear Gentlemen

I get information from different department come to me as updated to standard excel form template. and i copy all the updated data to another excel file in the C drive used as Database.

My questions a

Can I program a code in VBA in the form template to transfer the data to the master database automatically, if we assumed that all the data which we want to transfer from the form to the database are available in separate sheet in the form named link and the data range are A1:K1

Highly appreciate your support


Plese Guide me how to go about this.

i have excel sheet with data with say two columns Name and Number. This file contains many records say about 100. I ahve to fill Web Form using this data. Presently what I am doing is opening internet site, opening Web Form , Minimise Internet Explorer, copy Name field and pasting it to Web Form, again copy Number field and paste it on Web Form. I want to automate it through Excel User Form or vb code.

Any ideas?

I am planning to send a database to many users to input data (each one will
be a separate file, not a linked db). Most users do not have Microsoft
Access installed on their computers, but all have Excel, so this will be an
Excel file. I would like to have a User form to make data entry easy, but
creating a complex User form in Excel is a lot more difficult than in Access
(I don't want to write all the VBA code, and entry form is too complex for
the the Data->Form function already in Excel).

Is there a way that I can use Access to create a form and then import the
form structure into Excel? Basically I want an Access front-end without a
user having Access installed. Also, I want to do the data analysis in Excel.

By the way, I have Access 2003 and Excel 2003.

Thanks for the help.

In my file (excel 2007) I have several sheets that I need to upload into Hyperion every month. To do this manually I have to select a sheet , select the Hyperion tab (available on startup but only after installation) and then press submit. If I use the macro recorder the action of pressing submit, or selecting the Hyperion tab, yields no code. How to I program a macro that selects one sheet, submits the data, selects the next sheet, submits data etc?

I have an excel form, I want my users to be able to open the form, fill in appropriate data, then click the save button. When the button is clicked, the data in the form should be saved to a new file and then the original form should be reset (clear all values) for a new set of data entry. When the data is saved, I want the new excel sheet to be saved to a location specified within the macro so the user doesn't have any options and I want the title of the new file to be the value of one of the cells.

I'm new to macros and would appreciate any help this board can offer. Thanks...

Hi there-

I want to be able to drop a file into a specific are of an access form that will trigger VBA to save that file into a specific directory and rename it with data from fields in the open form.

Can anyone point me in the right direction on what control I might be able to use that will allow an Access form to recognize that a file is being dropped into it, 'take control' of the file and kick off the appropriate VBA to save the file out to where I need it stored?

Secondly, once I have this down I'd like to know how to have a link to the file auto populated in a field of that same form.

Thanks in advance-

I am using Excel 2003. This particualr VBA file I am running I have run many
times. It has been about 2 months since I have run it though and I do not
recall making any changes to my settings, but maybe you guys can help.

When you open the excel file, it opens a database in the background that is
not visible. However, when I open the excel file I get an active X component
can't create object error. when I open up the VBA tool, it stops where the
program is trying to open up the databse. I looked at my references that are
checked and none of them appear to be missing.

I realize that this is very vague, but hopfully someone can give me some
suggestions to look for.


Hi All,

This is my first post on this forum... I'm hoping someone here can help me with this...

I'm trying to transfer data from a shared access .mde file into an excel worksheet using vba in Excel.
Ive seen numerous samples of code on the net on how to connect to the source .mdb file and copy records from the table.
My problem is that the .mde file doesn't store the table. The values are only accessible through the form.
(so the ADO open table soure doesn't work, see

I can do a manual Copy of the values from the form using "Datasheet view" which displays all the values in table view, and then pasting them into
Excel, so I believe this can be automated with VBA, If I can get the commands to access the form rather than table, does anyone have any Ideas?