This discussion is archived
1 Reply Latest reply: Oct 28, 2013 4:31 AM by SiddN RSS

Smart View Ribbon not shown when Excel is invoked using VBA

SiddN Newbie
Currently Being Moderated

Dear Hyperion Gurus,

 

I am in need to invoke smartview refresh by calling excel using VBA from an excel module in another sheet(master template). But when I invloke Excel using VBA, smartview ribbon does not get activated, due to which the HypConnect, HypVMenuRefresh command does not work. If I directly open excel and run the module it connects fine and does the refresh without any problem. I have tried to enable and disable smartview using VBA but it does not work either. If I call excel directly using a batch using Call command, then it works fine, however the batch file does not close as if I use ThisWorkbook.Close command, then it does not completely close Excel, the instance still runs, and if I try to close using Application.Quit, then it closes down Excel completely. Any help would be highly appreciated.

 

Thanks and Regards,

SiddN.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points