Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding out programmatically how many rows in excel.
Message
From
27/01/2003 16:12:49
Jorge Haro
Independent Consultant
Juarez, Mexico
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00745897
Message ID:
00745984
Views:
26
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
Map
View

Click here to load this message in the networking platform