Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Small problem with Excel .Range
Message
From
12/10/2000 15:58:30
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00428701
Message ID:
00428738
Views:
17
Jaroslav,

When I recorded a macro and clicked the upper left square, which selects the whole sheet I got
Cells.Select
    Selection.Copy
>I create a excel file and I don't know determine size of text in sheet.
>I think that my solution is not good and I use .Range("A1:IV256")(maximum size). I need this 'text' puts to another app.
>
>PUBLIC sgoExcel, sgoExcelRange
>sgoExcel = CREATEOBJECT("Excel.Application")
>IF TYPE("sgoExcel") == "O"
>sgoExcel.Workbooks.Add
>sgoExcel.WorkBooks.Open(pjsFileName)
>sgoExcel.Visible = .F.
>WITH sgoExcel.Sheets[1]
> sgoExcelRange = .Range("A1:IV256") ** ????
> sgoExcelRange.Copy()
>ENDWITH
>
>
>Thanks.
Previous
Reply
Map
View

Click here to load this message in the networking platform