>Will that do Yes!! That was the piece of code I needed.
Thank you very much and have a nice weekend Rafael ----- Original Message ----- From: "Peter Hart" <[email protected]> To: <[email protected]> Sent: Friday, December 04, 2009 2:58 PM Subject: RE: Excel automation > Hi Ralph > > oleExcel = Createobject("Excel.Application") && Create Spreadsheet > With oleExcel > > .Visible = .T. && Show Excel > > lcPath = Path to your Excel File > lcFileName = Name of File > > .Workbooks.Open(lcPath + lcFileName) > > For lnCount = 1 To .Sheets.Count && No of sheets in Work Book > > && Pick up data from Work Sheet > > EndFor > > EndWith > > > Will that do > > Peter > Peter Hart Computers > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Rafael Copquin > Sent: 04 December 2009 17:45 > To: PROFOX > Subject: Excel automation > > I received a Excel sheet from a client, containing all transactions from > his suppliers's accounts. > However, there is one page within the file for every supplier. > > I wish to write a little program that will read the first sheet, copy > the contents to a table and then go to the next sheet, do the same and > so on. > > I know how to do this for a single page Excel file, but not for a > multipage one. > > Can someone give me a lead on how to do this? > > TIA > > Rafael Copquin > > > --- 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/224814d965d84cd480ed1d7fb4d56...@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.
