This expect script does the job (thanks to 'zedwood' )
#!/usr/bin/expect -fset filename [lindex $argv 0]set timeout -1spawn scp $filename myusername@192.168.1.123:/home/myusername/set pass "mypassword"expect { password: {send "$pass\r" ; exp_continue} eof exit}