I have a pretty standard WinSCP SFTP script that grabs a few files and saves them to a SharePoint library. The script gets called from VBA so I cannot leave lcd blank. The location of the library is slightly different for different users so I need a way to get the script's location.

The script is stored in a synced SharePoint folder: %USERPROFILE%\User-Path\FTP\

For other users that path might be %USERPROFILE%\UserPath-FTP\FTP.

@echo off

"C:\Program Files (x86)\WinSCP\WinSCP.com" ^
 /command ^
    "open sftp://mysite.gov/ -hostkey=""ssh-rsa 4096 key#######=""" ^
    "cd /" ^
    "lcd ""