I found that when we protected the excel file structure and allowed management to put in all of their facts for vendors. We then read the sheet after otwaa emailed in and saved off as XML file. Our app then sucked in the XML and we processed all of the changes.
Sent from my iPhone Stephen Russell 901.246-0159 On Nov 9, 2009, at 6:33 AM, "Rafael Copquin" <rcopq...@ciudad.com.ar> wrote: > In cases like that, and provided that you know in advance what the > outlay of > the Excel sheet is, you can use automation. > > I have, for instance, a fixed Excel sheet that a module of my sales > program > produces, every time a salesperson wants to send a customer order, > from > his/her notebook, via internet, to the head office. > > The salesperson fills up an order form for whatever a customer > purchased, > the program then issues an Excel sheet with the order. This is done > using > automation. This sheet is sent by mail to the head office. The clerk > at HO > downloads the sheet into the salesperson's file folder (every > salesperson > has a separate folder) and the HO program then reads the Excel > sheet, using > automation. The info is then integrated with the company's ordering > system. > > The thing you have to make sure of is that the Excel sheet is always > the > same, IOW, you place every detail of the purchase order in the same > relative > cell. Then you can write an automation routine that will go to each > particular cell, read its contents, and place the info into whatever > control > your application uses, such as a textbox or a grid. > > Rafael Copquin > > > ----- Original Message ----- > From: "Sytze de Boer" <sytze.k...@gmail.com> > To: <profoxt...@leafe.com> > Sent: Monday, November 09, 2009 12:21 AM > Subject: Importing from Excel 2007 > > >> I need to update my system where my app does: >> >> appe from (xlfile) type xls >> >> I have a site where some users have Excel 2003, and some have gone to >> Excel2007 >> This creates problems. >> >> I've checked the archives and downloaded a system from Sweet Potato >> This pops up Select Data Source (and my clients will run away) >> >> It looks like I also need to read something that used to be with >> Advisor >> but >> I let the sub lapse >> I've tried to locate the author David Hagen but can't find him. >> >> Can I ask what my "profox buddies" are doing ?? >> >> -- >> Regards >> Sytze de Boer >> Kiss Systems >> Hamilton, NZ >> Ph: 64-7-8391670, Mob:64 21 937611 >> URL: www.kiss.co.nz >> >> >> --- StripMime Report -- processed MIME parts --- >> multipart/alternative >> text/plain (text body -- kept) >> text/html >> --- >> [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/aafd4b10-e275-468b-9e24-b6b3f88b5...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
