vba(SOX): ftp connection & hard coded password

[Gurinder]

Hi,
We have a VBA application and some data is sent using ftp. But the
user id and password are hard coded inside the code. This is not SOX
compliant. Is there a wayout to this problem??

Thanks,
Guri

 

[Bob Phillips]

Could you just use an Inputbox to prompt for the id & password within the
app?

--

HTH

RP
(remove nothere from the email address if mailing direct)