how to hide a password in macro?

[david.dienes]

Hi All!

How to hide a password used in Project macro code?

I tried to hide all the code with setting "Lock project for viewing" in Project Properties, but this caused to have Run button disabled (greyed out) for users...

Using global template in Project Server 2003... (though might be the same solution as for 2007)

Thanks,
David

[ssanderlin]

Originally Posted by david.dienes

Hi All!

How to hide a password used in Project macro code?

I tried to hide all the code with setting "Lock project for viewing" in Project Properties, but this caused to have Run button disabled (greyed out) for users...

Using global template in Project Server 2003... (though might be the same solution as for 2007)

Thanks,
David

There's really no good way to do this, since any crypto routine you write would be right there, ready to run.

[david.dienes]

My task is: get data from SAP via RFC call. How would you implement this with not showing the password? Maybe I shouldn't use macro?

My present solution shows password:
Set objBAPIControl = CreateObject("SAP.Functions")
Set sapConnection = objBAPIControl.Connection
With sapConnection
.Destination = "SQ1"
.ApplicationServer = "111.111.111.111"
.Client = "100"
.User = "RFC_REMOTE"
.Password = "XXX"
.Language = "EN"
.SystemNumber = "00"

[ssanderlin]

Originally Posted by david.dienes

My task is: get data from SAP via RFC call. How would you implement this with not showing the password? Maybe I shouldn't use macro?

My present solution shows password:
Set objBAPIControl = CreateObject("SAP.Functions")
Set sapConnection = objBAPIControl.Connection
With sapConnection
.Destination = "SQ1"
.ApplicationServer = "111.111.111.111"
.Client = "100"
.User = "RFC_REMOTE"
.Password = "XXX"
.Language = "EN"
.SystemNumber = "00"

Since you need to store the password, I would do this in a VSTO add-in rather than a macro.