Password protected server

[Sahak]

Hi All,

I have excel program which gets data from server, address is like: \\ABC\Data\Items.xlsb
It was working perfect, now company put password on server folder (let say “sunset”)
What should I add to my macro to open my file “Items.xlsb” from protected server ?
Thank you in advance

 

[mole999]

discuss with your IT department on their preferred option for connection strings

 

[Sahak]

Hi Mole999,

Thank you for reply,
The IT department can give password only, they have no idea about Excel macros ........ ?

 

[mole999]

the answer maybe in here > https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-syntax

 

[Sahak]

Thanks again, I'm sorry, I totally confused, I expect to get a macro code.