title: How to Refresh Excel Smart View Essbase using Macro
body: <p>I'm using below code to refresh Essbase feeds in my workbook and it is working nicely, however, the only downfall is that I need to enter password every time I refresh the essbase as our Essbase system is highly secured. </p>
  
  <p>My question is, is it possible to incorporate the Password in the macro so that I don't have to enter the password every time I refresh the feeds.?
  Solving this problem would also enable me to automate this whole process through Python and schedule a job. </p>
  
  <pre><code>Private Declare PtrSafe Function HypMenuVRefreshAll Lib "HsAddin" () As Long
  
  
  Sub RefreshHFM()
  
  Call HypMenuVRefreshAll
  
  End Sub
  </code></pre>
  
  <p>Any help.?</p>
  
  <p>Thanks.</p>