We are having Full client reports (Converted from 6.5 to Xi r2 Deski). earlier in 6.5 we used to call the custom macro while scheduling the report thru’ BCA. Since in XI r2 it is not supported so we changed the code to call that macro after document_afterrefresh function. When I manually refresh (Without scheduling thru CMC or Infoview) the document is getting refreshed and then it calls the macro (due to afterrefresh function) and works fine. But when I schedule the document then it simply refreshes and shows status as Success but the VBA part is never executed. What could be the issue? I am banging my head from some time on it now.
Did you get the response from tech support. I logged case too and we noticed that there was no VBA folder on the server to process the macros. I just want to confirm that this was the case with you too. I will appreciate if you can confirm.
I was able to refresh using VBA a scheduled instance but in my vba code i was saving it to a enterprise folder, here there is some issue where it saves the report with some weird characters as report name and not the one which is being refreshed. And the tech support has escalated it to the Product group and we are yet to hear from them. I am looking into other ways of doing this like using program object.
You may have seen this earlier post discussing some of the limitations regarding VBA functionality. That post also references a migration document that provides more detail.
(BOB member since 2003-03-10)
(BOB member since 2004-05-03)
(BOB member since 2004-09-28)
(BOB member since 2006-02-13)
(BOB member since 2002-09-19)