FTPGetFile problem with Space in File Name

[TommyJ]

MS Version 7.2.038e on Windows 2000, Excel '97

Here's my code...

let>savePath=H:\Report_RunnerTesting\
let>bondAddr=bm-prod.ext.us.bank-dns.com
let>rcPF_FTCIM=R1C2
DRQ>Excel,H:\PrintFiles.xls,%rcPF_FTCIM%,PF_FTCIM,10
ConCat>savePath,FTCIM.txt
FTPGetFile>%bondAddr%,FTC_FTP,***,21,%savePath%,%fLoc_FTCIM%,A

I get this error:

500 ' ': command not understood by Sidewinder proxy.

When I replace %fLoc_FTCIM% with
$1$DKA101:[FTCIM_REPORTS.PRINT.MISC]PRINT-01-09-04-012-NRW32
it works without a hitch.

I've checked the spreadsheet and there are no spaces in the cells... Can anyone tell me what is wrong with this?

[TommyJ]

although i'm curious why the above didn't work, i've changed the code to use input from an ini file, now it works fine

[support]

let>savePath=H:\Report_RunnerTesting\
let>bondAddr=bm-prod.ext.us.bank-dns.com
let>rcPF_FTCIM=R1C2
DRQ>Excel,H:\PrintFiles.xls,%rcPF_FTCIM%,PF_FTCIM,10
ConCat>savePath,FTCIM.txt
FTPGetFile>%bondAddr%,FTC_FTP,***,21,%savePath%,%fLoc_FTCIM%,A

Well, fLoc_FTCOM doesn't exist anywhere in your code. You have a variable rcPF_FTCIM and PF_FTCIM but I see no fLoc_FTCIM, so I expect that was the problem.