Forum Discussion

rafaelschmitz's avatar
rafaelschmitz
New Member
7 years ago

Error opening a power bi desktop file using VBA

Hi All,

 

I'm trying to open a pbix file through a VBA code file after updating an excel database. I used the following commands in VBA:

 

MyFile = "filepath"
Cmd = "RunDLL32.EXE shell32.dll,ShellExec_RunDLL "
Shell (Cmd & MyFile)

 

But when it does that, Power BI starts with a error message that says: "Ribbon view has not been initialized"

 

Do you have any idea why I'm having this error? Is it the method I'm using to open the file? Do you know another way to do it?

 

Thanks,