Question about inserting a variable

[mpcluever]

I have a line that transfers files through FTP

Run('"C:\Program Files\Ipswitch\WS_FTP Professional\wsftppro.exe" -s "01724:/home/sicom/public_html/mgrngdata/var/sicom/PREVDAYS/SUN/*.pdf" -d "local:c:\Sicom Files\Data Files\SUN\01724\"')

How would I make 0174 variable? With all the quotes, the variable just becomes absorbed by the rest of the string.

[Valuater]

Not tested...

$var = "01724"

MsgBox(0x0, "", '"C:\Program Files\Ipswitch\WS_FTP Professional\wsftppro.exe" -s "' & $var & ':/home/sicom/public_html/mgrngdata/var/sicom/PREVDAYS/SUN/*.pdf" -d "local:c:\Sicom Files\Data Files\SUN\' & $var & '\"')

8)

[martin]

I have a line that transfers files through FTP

Run('"C:\Program Files\Ipswitch\WS_FTP Professional\wsftppro.exe" -s "01724:/home/sicom/public_html/mgrngdata/var/sicom/PREVDAYS/SUN/*.pdf" -d "local:c:\Sicom Files\Data Files\SUN\01724\"')

How would I make 0174 variable? With all the quotes, the variable just becomes absorbed by the rest of the string.

I think this should do it

$value = "01724"
Run('"C:\Program Files\Ipswitch\WS_FTP Professional\wsftppro.exe" -s "' & $value & ':/home/sicom/public_html/mgrngdata/var/sicom/PREVDAYS/SUN/*.pdf" -d "local:c:\Sicom Files\Data Files\SUN\' & $value & '\"')

Edit:Too slow!

Edited September 7, 2008 by martin

[mpcluever]

I think this should do it

$value = "01724"
Run('"C:\Program Files\Ipswitch\WS_FTP Professional\wsftppro.exe" -s "' & $value & ':/home/sicom/public_html/mgrngdata/var/sicom/PREVDAYS/SUN/*.pdf" -d "local:c:\Sicom Files\Data Files\SUN\' & $value & '\"')

Edit:Too slow!

That did it! Thanks a million!!