Excel RefreshAll using powershell script along with credentials

Question

I need to refresh an excel using Powershell script (so that I can later schedule it in task scheduler). This refresh requires credentials to be entered. Does anyone know of a way to pass these credentials from the powershell script? The excel hangs at RefreshAll() for the user to enter the credentials.

share the code. what do you mean by refresh. Are you trying to reload the file? — Ranadip Dutta, May 17 '17 at 08:14

score 0 · Answer 1 · edited May 23 '17 at 12:18

0

You could probably use the pscredential object to provide the credentials. It is possible to store it to a file (encrypted).

save PSCredential in the file

Might be what you are looking for.

edited May 23 '17 at 12:18

Community

1
1

answered May 17 '17 at 08:14

Kjetil Mæland

39
4

Excel RefreshAll using powershell script along with credentials

1 Answers1