Information générale
Catégorie:
COM/DCOM et OLE Automation
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement