Bex workbook does not run properly on 2010
I have a problem with my workbook. This runs on the 2007 without error. I have the workbook
extended by a module. In this module, the date of filter taken out and inserted the TextQueryTitle.
When I start the workbook, you can see very briefly the date in the textQueryTitle. Then it disappears again.
I have set in my module one debugpoint to the end. When I run it up to this debugpoint, is the date.
If I press F8 and debug, he jumps to the end from sub MenuRefreshVariables (). When I look now
the workbook look at the date in the TextQueryTitle field is gone.
Here the sub function
Sub MenuRefreshVariables ()
On Error Resume Next
Dim lcmd As String
lcmd = pAddin.ExcelInterface.cCMDRefreshVariables
Call pAddin.ExcelInterface.ProcessBExMenuCommand (lcmd)
End Sub <-Here is the point where the debug is