General information
Category:
COM/DCOM and 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...
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only