General information
Category:
COM/DCOM and OLE Automation
Title:
Excel formatiing via Fox
I am trying to create spreadsheets via FoxPro into excel. I am able to get the data into the spreadsheets. The problem I am having is formatting the spreadsheet. I want to add underlines, subtotal, etc. The number ofrecords in my files constantly changes. So a formula that might fit in cell F35 on one day may need to be moved down to F60 or something the next day. This is what I have
> so far.
>
> With objExcel
>
> .Sheets("DC").Activate
> .Cells(1,1).select
> .Selection.End(xlToRight).select
> .selection.end(xldown).select
>
> This positions me at the end of the data block. I want to move down from here two or three cells and put a formula in place that will sum the entire column. I think I need to load the coordinates into a variable and add "two or three places" to that so it positions the cursor where I want the formula. How do I do that? Any ideas. Samples would greatly be appreciated
Next
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