Startup Folder Issue : Stop working "randomly"

[NotoriousPopol]

Hello community!

French Intern in Vietnam here. Received a lot of help from this forum to build my production planning, and now I need your help!

In order to fill a database (product data), I want to have a macro running from PERSONAL.XLSB from 2 computers. This is supposed to display data in any workbook on the server.

I worked on this macro in my computer, without any issue regarding the PERSONAL.XLSB file.

But when I try for my coworkers, it randomly stop opening... If I open manually the P.XLSB file, it works. But after a few Open/Close, I get a blank windows from Excel, and from then the Startup folder doesnt work anymore. Until I reboot or launch it manually.

I tried everything I found on the internet : Add-In list, change the folder, tried with a simplier macro, retry again and again... Still no issue on my computer, doesn't work for others.

We run on Office 2015.

Any ideas? I'm losing my mind on google right now... Should I forget the PERSONAL.XLSB solution and try something else? My macro includes a form and an ADODB Connection.

Cheers,

NotoriousP

 

[NotoriousPopol]

I finally used Add-Ins. I can't use a "Ctrl+" shortcut but at least it works. And easier to update I guess.

Still no answer for this bug! Excel is so annoying some times...

NotoriousP.