Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA and SAP Business Warehouse

VBA and SAP Business Warehouse

ResolvedVersion 2003

Fri 23 Jan 2009, 15:42 Delegate Maarten said...

Maarten has attended:
Excel VBA Intro Intermediate course

VBA and SAP Business Warehouse

Does anyone know if VBA is able to work closely with Business Warehouse? The SAP reporting tool?

Wed 15 Apr 2009, 14:21 Trainer Jacob said...

RE: VBA and SAP Business Warehouse

Hi Maartin

With regards to your post the short answer is there are probably ways to integrate Excel using VBA with Business Warehouse but this would require a greater understanding of exactly what yuo need to do and the requisite skill sets to make it happen.

This will be more of a consultancy requirement and should you wish to explore further please advise.

Regards

Jacob

Tue 21 Apr 2009: Automatically marked as resolved.

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

VBA and SAP Business Warehouse

VBA and SAP Business Warehouse

RE: VBA and SAP Business Warehouse

Excel articles

Excel tip:

Use the SUBTOTAL function in Excel