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" <[email protected]> To: <[email protected]> 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: [email protected] 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/29690462f7fd4381a8475140df190...@rafanueva ** 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.
