Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Finding out programmatically how many rows in excel.
Message
De
27/01/2003 16:12:49
Jorge Haro
Independent Consultant
Juarez, Mexique
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00745897
Message ID:
00745984
Vues:
27
Oh I see, I haven't tried anything like that, I don't know if the selected range affects the contents of the file that's saved, I would assume that "save as" saves the entire document, but anyway, have you tried it the other way around?, I mean, save the excel document as is and then do an "import from ... type XL5" in VFP?, that's what I usually do. I'll try to duplicate what you are trying and let you know.

>Okay,
>
> Here is the code I am using could you please demonstrate how I would incorporate that into my code....
>
>
>local lnRows
>lnRows=oWorkBook.Worksheets(1).UsedRange.Rows
>
>oWorkBook.Worksheets(1).Range("A1:T1").Select
>oWorkBook.SaveAs(sys(5)+curdir+'upenviro3.dbf', 8)
>
>
>I am trying to save Cell A + lnrows to T + lnrows, the way it is I get only the 1st row... I don't know the right syntax for A+lnrows:T+lnrows
>
>
>Thanks...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform