Howto Excel Subtotal

Prabhat · Joined: 04 Oct 2007 Posts: 21

Hi All,

I have to export the ADO records to Excel and perform some task in Excel.

I am almost doone but with out the "SUBTOTAL"

In VB I can work with the : Subtotal(GroupBy, Function, TotalList, Replace,
PageBreaks, SummaryBelowData)

In VB I Write like:
ExlObj.ActiveCell.Worksheet.Cells(4, 1).Subtotal 4, xlSum, (6), 0, 0,
xlSummaryBelow

So How do I do that in Delphi?

(I Know this is not DELPHI News Group. But I have posted n searched in many
delphi news group But did not help me so I am posting here so that any MS
Tech can help me)

Please HELP.

Thanks
Prabhat

Archived from group: microsoft>public>excel

Peo Sjoblom · Joined: 04 Oct 2007 Posts: 1

This is not an MS tech group, this is a peer to peer newsgroup, That of
course does not mean somebody could not help you with your question but it is
obvious that many people erroneously believe that this is a real tech support
forum. If you want MS support expect to pay for it

Regards,

Peo Sjoblom

"Prabhat" wrote:

> Hi All,
>
> I have to export the ADO records to Excel and perform some task in Excel.
>
> I am almost doone but with out the "SUBTOTAL"
>
> In VB I can work with the : Subtotal(GroupBy, Function, TotalList, Replace,
> PageBreaks, SummaryBelowData)
>
> In VB I Write like:
> ExlObj.ActiveCell.Worksheet.Cells(4, 1).Subtotal 4, xlSum, (6), 0, 0,
> xlSummaryBelow
>
> So How do I do that in Delphi?
>
> (I Know this is not DELPHI News Group. But I have posted n searched in many
> delphi news group But did not help me so I am posting here so that any MS
> Tech can help me)
>
> Please HELP.
>
> Thanks
> Prabhat
>
>
>

replace Excel 2000 -> Excel 2003 I am using the following code to edit data cell by cell: What:="", I get a Microsoft error "Microsoft Excel cannot find any data to replace. Check if your search formatting and criteria are defined correctly. I

Excel chart from VB to Excel Hi I've a Chart object in a VB6 form together with some text boxes, my question is can I "copy" the chart object from the form and place it in a Excel chart ?? I know I can create the chart in a Excel my question is can I

Excel and OLE Is there any way to take an Excel object, whether it be a chart object or range, and connect it to an OLE control to show the object? For instance, if I had: Dim objApp As Dim objBooks As Dim range As Excel.range Dim objS

Excel I am a bit of an expert at programming, but a beginner at VB. I have VB6.0 and I cannot seem to figure out just how to get information from Excel. I just want to write a simple program that can read Excel documents and write them out as text files. We

OLE Control with Excel I'm using an OLE Control to display an Excel Workbook in my VB6 application. When I Embed the Workbook, it appears in a minimized state. For a view of the Workbook that fills the entire OLE Control, the marquise needs to be dragged manually with the mou