Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA and SAP Business Warehouse
Resolved · Low Priority · Version 2003
Maarten has attended:
Excel VBA Intro Intermediate course
Does anyone know if VBA is able to work closely with Business Warehouse? The SAP reporting tool?
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:Formula for last day of monthIn some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1 |
TrustScore
4.8
/ 5
2236 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.06 secs.
