Public folders

Hello

I want to create a public folder with link that will allow an excel.xlsm doc to be opened in native excel (not web excel) without requiring a login.

Background- I have two .xlsm workbooks, workbook one is on my customer’s computer, and workbook two is in my skydrive public folder.

In workbook one, the customer runs a macro that open and interacts with workbook two and then closes workbook two in skydrive without my customer ever seeing it. This scenario works flawlessly on my computer but when I run it on another computer it requires a login.

Is there a solution for this? I don’t want my customers to have to login to MS.  

Thanks for your support

Paul