MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Office 2003 Subtotaling Issue

  Asked By: Rainhard    Date: Mar 07    Category: MS Office    Views: 621

I've a problem, not sure it's a bug or not? I've an Excel VBA
application that was running on Win2000 Server and Office 2000. Last
week the same application I've migrated into Win2003 Server and Office
2003. The application is behaving abnormally. My subtotaling utility
is getting disturbed.

Is any one has come across this problem earlier? Or it is a BUG !!
If anyone has the solution pls.



2 Answers Found

Answer #1    Answered By: Willie Gomez     Answered On: Mar 07

1) Where's the code?

2) What is "disturbed"? Be a bit (actually a lot) more specific.

Don't expect a bug. However, there might be an incompatibility between your
VBA 2000 code and Excel 2003.

Answer #2    Answered By: Pravat Jainukul     Answered On: Mar 07

My code is fetching the data from oracle and dump it on excel sheet, then I'm
subtotaling on basis of the passed values

Here is the code that is getting disturbed

Selection.Subtotal GroupBy:=CInt(sGBy), Function:=xlSum, TotalList:=iSub(),
Replace:=bReplace, PageBreaks:=bPageBreak, SummaryBelowData:=bSummary

sGBy is a string (denotes Group By)
iSub() is an array.
The same code is running fine in Office 2000 SP3. Subtotal is not positioning
where it's expected to display.

Didn't find what you were looking for? Find more on Office 2003 Subtotaling Issue Or get search suggestion and latest updates.