Workbooks.Open from OneDrive pops Microsoft sign-in dialog

[Celly]

This is annoying, I have a local copy of a spreadsheet which has a VBA script to import data from an xlsm on a OneDrive directory. Even though OneDrive is already running and logged in, the Workbooks.Open line will result in a Microsoft sign-in dialog popping up (Type the email of the account you would like to use to open...). If I simply close the dialog without logging in, the VBA script opens and imports the data successfully. I tried setting the ReadOnly parameter to true, however this doesn't fix it. Any ideas?

EDIT: This also seems to be new behavior in Excel 2016 that didn't occur with Excel 2010

 

[yky]

I don't use onedrive. So, I can't test the method I'm going to recommend. The following code is used to turn off warning. It may work for you.

Application.DisplayAlerts = [COLOR=#000080]False
...your code here......
Application.DisplayAlerts = [COLOR=#000080]True[/COLOR][/COLOR]

 

[Jaafar Tribak]

If you know the exact window title/caption of the Microsoft sign-in dialog popup then you could run an OnTime or a windows timer routine just before it is shown .. The timed routine will then retrieve the popup Window handle and send a WM_ClOSE message to it.