Does anyone have a tip on checking it the BW connection is up / if BEx is loaded in VBA?
I have a routine which refreshes data based on a BW query (separate sheet), and I don't want this routine to run if it will be unable to refresh the data. (Alternatively the trigger could be some sort of verification that the refresh of the query was successful.)
Any tips?