Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:


Advertisements


Free Excel Forum

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

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More




View Answers     

Similar Excel Video Tutorials

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...


Hi

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


Hi

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:
..\annualleave.xsn

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.

Thanks,


Melissa


Hi, I am tryng to conect InfoPath Form to Microsoft SQL Server DataBase. But I have no idea what "Microsoft SQL Server DataBase" actually mean

Does Microsoft SQL Server DataBase mean Access 2007 Database basically? I have the form build in to submit few lines of data from sharepoint and then once submitted throw the data to Database in network drive. Does it work this way? 'm kind of confused and dont know what to do....so please suggest, please advice [I have no prior expirience as such...]


Thank you soo much for helping.


Are there any eager, helpful SharePoint/InfoPath mavens out there? Failing that does anyone know a good, smart, active user group that could help me with these questions?

I have a couple of questions about using InfoPath 2010 to populate a SharePoint 2007 form library:

1. When editing within SharePoint is it possible to set up SharePoint to use the original InfoPath form as the editor - to make us of the pull down menus - rather than the default editor template?
2. Is it possible to create a field that equals the SharePoint ID # plus a constant value?

Thanks as ever

C


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?

Thanks,
Roger


Hey guys,

I have created a data access page which I am going to be basically be using as a form to submit data to my database (pretty much to overcome the limitations of infopath with memo type fields).

I have the form sorted however I want to create a submit button. When you click this button it will save the record and redirect you to a thank you/confirmation page. I will then have on this page a link to close the browser or a link to add another entry to the form.

Can anyone show me an example of some code which will save record and redirect?

Thanks,

Chris




Good afternoon

I am currently built a form using Microsoft Infopath and want some of the information on this form pulled through into a new form - things like Title, Date, Name etc

Is this something it can do?

Thanks

Hi Everyone,
Hope this is the right thread section for this question.
I have a form in Infopath that will be accessed by several people and I want them to export to excel. Is it possible to export this data to the one spreadsheet or does it have to be a new one each time? I have been cutting and pasting to my master spreadsheet.
Thanks for any info.


Hi guys, I'm not extremely proficient with Excel so please bear with me.

I have 2 excel sheets, one is a Submit Form that the user fills out and hits 'Submit' on, and the other is a tracking sheet which pulls information from the Submit Form via a macro. The problem I'm having is that when I tell Excel to open the Tracking file and grab information and fill in from the Submit form, it actually just fills it in on the Submit form itself on the cell that I told to fill in on the tracking sheet - NOT the actual tracking file. Below is the code:

Code:

'Opens Tracking File
    Workbooks.Open (dir & "\Database\Issue Tracking.xls")
    
    Sheets("Tracking").Activate
    ActiveSheet.Unprotect
    
    Cells(8, 2).Formula = "='[New Submit Form.xls]Submit'!$G$3"


So what I'm getting, is "=Submit!$G$3" in B8 of New Submit Form, where I need that formula in B8 of Issue Tracking. Can anyone help?




hi..

i have a form
i accept some user inputs in the form. there is a link on the form from
where i open the excel file in the same browser (not in a new
page...simply using a href. i am also accepting input from the user in
the excel.

now i want to save the data in excel as well as on asp form.
i can save directly thru vba code in excel to the db. but suppose the
user comes back to the form and somehow doesnt click the submit button
of the asp form to save the data. then it would mean that i saved a
certain piece of data in the db thru excel and the other relevant data
didnt get saved at all!

so i revised my approach. now what i want is that when i click the
submit button on the form i want to save the excel data also.

for this what i am doing is...when i open the excel template i let user
enter data inside it and then i will let him a copy of the excel file on
his machine(cleint machine). so in the end when the user clicks the
submit button i will
1. save the form data in database
2. open the excel file stored in clients machine
3. run a procedure inside it whihc save the data in the db

can i open the excel file on button click on asp form and then run a
macro in the excel file?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Hi everybody;
I have a problem related to Infopath forms. When the users try to open the form, they face to a prompt window on which they should select one of "Read Only / Edit" options.
If a form's Edit option is selected by the user A, then the user B has no permission to edit.
But I want to let all users edit the same infopath form at the same time.
For solution of the related problem, I searched and found that it can be accomplished through a webinterface (cgı based or not, I have no idea)
Also another solution I found is using javascript that controls these 2 options (Read / Edit)
Can anyone any idea to solve this issue?

Hi,

I'm trying to develop a temporary Excel database system at work until we can get hold of a proper Database system. I would like to create a function using a button to generate VBA code that will submit form data from one Excel document into a general repository within a separate Excel document.

Many people will use the form.xlt file to enter data and submit it to the database.xls file. I cannot find anywhere online which will show me how to connect to another Excel file, create a recordset of the data being capture in my form, and then exporting it to my database xls document.

Many thanks to anyone who can help me out on this.


Hi all!

I am trying to create custom properties in Word. I have read all sorts of help files and I get the feeling I need to use InfoPath to do this. I have never used this program before.

I have Microsoft Word 2007 and Microsoft InfoPath 2003. I get that I need to create these "custom properties" in InfoPath and then somehow attach the file to Word using the Developer tab on the ribbon. If this is correct, can someone help me out with how to do that?

Basically, in Word, you know how there are property entry areas for keywords, category, status, etc.? I want to add some more fields like: Applications, Government Agency, Prime/Sub, and Capabilities. I want to be able to simply type text into all those fields and then be able to search on them later, much like typing something into the keywords area.

Can someone dumb down this process for me and help me out? Thank you!!


I have a form where people enter in data and submit it. The form puts the data in specific cells. What i am looking to do is when the form is opened again the data they entered the first time will remain in the text box.

I have accomplished this with
Quote:

Sub Showform()
Form.Show
End Sub

Private Sub Form_initialize()
Form.TextBox.Text = Range("B1").Value
End Sub



Private Sub Submit_Click()
Range("B1").Value = Form.textbox.Value
Form.hide
End Sub


this seems to work if I open the form type something submit it and then open the form again, but problem is if i save the file close it and reopen it the form wont populate with the value of B1 like it did before (the value does still exist in B1)

Any thoughts?


Hey all,

Upgrading to the latest version of Office has given our company access to Infopath (which is used to make forms, which is where a great number of my Excel programs were previously used.)

In Infopath the user can select which language they want to program their macros in. I have the following choices:
JScript
VBScript (It seems this is what Excel uses)
C#
C# (Infopath 2003 compatible)
Visual Basic
Visual Basic (Infopath 2003 compatible)

So my question is that since I already have a great deal of code in VBScript and a fairly solid understanding of the language, is there anything desirable about the other languages that would be worth switching formats? Does anyone have any recommendations and places they go for hints tips on the other languages?


Hi,

In column A and B in excel I (hope to) have a list of (infopath) file paths. There is one file path in each cell but the length of column A or B i.e. the number of files varies, there may even be blank cells in between used cells. How can I get excel to open and close each file in turn (so that only one file is open at a time)? Can I build a delay between the opening and closing so that infopath has a chance to do its thing.

Thanks.


Hi

Used to have 52 individual Excel timesheets to keep track of working hours. This time was cumulated in a global Excel spreadsheet that had simple references to a cell in these external workbooks. Example:

='D:\My Documents\Admin\Hours\2007\[Time-Week-05.doc.xls]Timesheet'!$H$32
='D:\My Documents\Admin\Hours\2007\[Time-Week-06.doc.xls]Timesheet'!$H$32
n...52

The company has now converted the weekly timesheet from Excel format to an InfoPath form (XML) with tables and cells. There is still 52 individual forms, one for each week.

Is there a way to update links in the global Excel file to read specific data in these InfoPath forms? For example:

='D:\My Documents\Admin\Hours\2007\[Time-Week-05.doc.xml][SpecificCellfromXMLFile]

There is little documentation on how to achieve this and what format should be used for such links if they are possible.

I guess an alternative would be a static XML import, but this would be a second option.

Any help with this conversion would be appreciated.
Thanks in advance

Erik


There is a form on the web with 10 entry boxes, a submit button. Once you press submit, the results are displayed.

Is there any way to automatically populate the 10 entry boxes with data that is located within 10 cells in an Excel spreadsheet? And then automatically press submit?

I would like to have a first submit box in Excel that would run some kind of macro that copies the 10 numbers and then submits, so that all I will see in the end will be the output results.

Thanks if you can help!


I have an Excel worksbbok which is rather huge and the data are spanned across multiple pages. Can I create a view where I input the Month (or the sheet name) and the current windows will just show me that particular month I input.

Difficulties is that the data has to be pull in from different sheet, even if the sheet names are predictable (Databse-Jan, Databse-Feb, Databse-Mar... etc) it is quite difficult for me to visualize how to do it.

Can anyone advise? Without macro.


Reason I ask is that I work within a health care information role and would love to get the hand of infopath for setting up pro-formas linked to various databases.

If there's anyone out there with experience in this could they PM me. I'd like to know the advantages of using this software.


Hello,

I'm a complete Access newbie but I need to create a form so I could use some help.
I've created my tables and a form. The users will submit multiple records (test scores) using this form and some of the fields can remain the same during the testing session (i.e. the submiter's info). Is their a way to create a button that will submit the record to the db without clearing all the fields until the form is closed (or I can create a button to clear the form).

Thanks for any help


I am trying to get Excel to fill in a form, submit the form, and then repeat the process on the second page. I have tried some of the stuff that directly submits data to the website and the response to the form is that the session has timed out. Essentially, when I use excel to submit the form directly (something like this . . .

URL = "http://www.website.com?A=aa&B=bb
sHTML = Inet1.OpenURL(URL)

)
The website will say that I have an inactive session on the next page rather than returning the second page with the second form that needs to be filled out. Is there a way to manipulate the website directly so that Excel is essentially clicking the submit button as if a human were on the website? Once the first page works, I would think that I can simply repeat the process on the second page. Because the website requires you to fill in preliminary data, submit the form, then fill in additional information on the second page, as opposed to simply sending data directly to the server, I haven't been able to find any guides for coding this up in other forums.

Maybe a stupid question but I'm a beginner so any help is appreciated.


Do any of you use InfoPath? Are there advantages to using this over excel for forms?

Is it "friendlier" to use by other programs?

Just trying to figure out why the IS dept. wants to use this over Excel for one of the forms.

Thanks.


Is there a way to create an XML macro that occurs on a button click where it would create the following xml and then save the xml to a location that I specify in the macro? Where it says 'CELL X# is the cell I would need to populate that field in the xml.

All of the infopath stuff needs to stay in there for the time being because I will be trying to save it to an infopath form library on a sharepoint site.

I would also need to make sure all the cells used in the xml are not null.