At the moment I am working very hard to get my book done, so this is only a short blog post how to use SAPGetVariable with VBA. The Analysis Office help provides no example so here it is:
| 1 2 | Dim ret As Variant ret = Application.Run("SAPGetVariable", "DS_1", "0S_CUS", "INPUT_STRING_AS_ARRAY") | 
So the command need the data source and the variable, in my example DS_1 and 0S_CUS. It is very simple, but at the moment there is no example in the Analysis Office user guide.
These posts might also be interesting:
author.
I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.
 
                                            
                    
                        
    
                SAP Analysis for Office - The Comprehensive Guide     
                            
                
                                                            
    The book SAP Analysis for Office - The Comprehensive Guide by Tobias Meyer is a pdf book about SAP Analysis for Office. It is based on Analysis for Office 2.8 and contains 346 Pages.
                                                                                        
                        
                                                        45,00 €
                                                        
                                                             
                        
                     
                                            
                    
                        
    
                SAP Analysis for Office - The Comprehensive Guide     
                            
                
                                                            
    SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.7 and contains
    299 Pages.
                                                                                        
                        
                                                        37,00 €
                                                        
                                                             
                        
                     
                                            
                    
                        
    
                SAP Analysis for Office - The Comprehensive Guide     
                            
                
                                                            
    SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.6 and contains
    272 Pages.
                                                                                        
                        
                                                        27,00 €
                                                        
                                                             
                        
                    
Write a comment
empfl (Friday, 26 March 2021 11:11)
This is very intressting.
I although look for an example
Tobias (Friday, 26 March 2021 12:15)
Hi,
is this not enough for you? Do you need more details?