https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/10659.aspxTue, 21 Nov 2006 09:08:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:10659Patrick Halstead0https://www.infopathdev.com:443/forums/thread/10659.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=10659Hi Turnipboy!<br />Sorry for the weeklong delay in responding! So long as you have the 1235 data somewhere in the form, you can do this with a Full Trust solution and some code. Or, you can save your Excel files to SharePoint and load them from there and you might be able to get around the full trust issue. Anyway, good luck!https://www.infopathdev.com:443/forums/thread/5917.aspxTue, 14 Nov 2006 10:09:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5917Turnipboy0https://www.infopathdev.com:443/forums/thread/5917.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5917Hi,<br /><br />I use an external Excel xml spreadsheet as a data source for sales order data in my infopath form. However the name of the spreadsheet that is used varies and depends on the sales order in question so if someone is filling the infopath form for sales order 1235 I want the infopath form to automatically choose the excel xml spreadseet c:\my_excel_files\salesorder1235 to grab data from. Can this be done e.g. by using the text box that the sales order is entered into in my infopath form to alter the filepath of the data source?<br /><br />Thanks.