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/a57fa4cf19531343a2ee11b57db8e3af100...@server.peterhartcomputers.local
** 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.
