Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Albert itkin
  Where is Albert itkin?
 brooklyn
 New York - United States
 Albert itkin
 To: Whoosh Diaz
  Where is Whoosh Diaz?
 
 Guam
 Whoosh Diaz
 Tags
Subject: RE: Excel VFP7 data transfer Emergency -- PLEAS...
Thread ID: 33934 Message ID: 34083 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Microsoft Office Automation
Date: Monday, December 08, 2003 5:57:06 PM         
   


>
> Thanks for the help !!! If I may bother you one more time, what's the VFP syntax for searching for a particular sheet in a workbook?
>
> Thanks again,
>
> Kim

You can create an array with all Sheet Names i workbook

oExcel=createobject("excel.application")
WorkBook=oExcel.Workbooks.Open(infile)
DECLARE SheetNames[oExcel.Sheets.Count]
LOCAL i
FOR i=1 TO ALEN(SheetNames)
SheetNames[i]=oExcel.Sheets[i].name
ENDFOR

Or if you know sheet exists just say

oExcel.Sheets(SheetName).Select

ENTIRE THREAD

Excel VFP7 data transfer Emergency -- PLEASE HELP! Posted by Whoosh Diaz @ 12/5/2003 6:58:30 AM
RE: Excel VFP7 data transfer Emergency -- PLEAS... Posted by Karben Selim Mejia @ 12/5/2003 4:19:52 PM
RE: Excel VFP7 data transfer Emergency -- PLEAS... Posted by Albert itkin @ 12/5/2003 4:38:58 PM
RE: Excel VFP7 data transfer Emergency -- PLEAS... Posted by Whoosh Diaz @ 12/6/2003 2:02:41 AM
RE: Excel VFP7 data transfer Emergency -- PLEAS... Posted by Albert itkin @ 12/8/2003 5:57:06 PM