Open the WS_FTP Server Manager. In the Explorer-style tree on the left, expand the branch for your domain. One of the sub-branches is "SiteCmds". Click on this branch. Click on "New CMD..." Give the command a name, e.g. "RUNXL" For the path to the executable, put in the path to your Excel program. (Use the [...] button) For the arguments, enter the path to the Excel file. (There must be no spaces in this path.) Click on Finish.
>From the client, connect to the server. Right click on the Right Pane. Choose "Operations" -> "FTP Commands" -> "SITE" In the box type RUNXL and press OK. Excel will start on your server and load the file. Notes: There can be no spaces in the path to the spreadsheet. Use the DOS name if necessary. For more control, you can create a batch file on the server that runs the spreadsheet so you don't need to specify an argument in the server config dialog. You can pass other arguments from the client to your SITE commands. Check the server help for more details on how to set these up. Note that command arguments may not contain spaces. You may also choose "Operations" -> "FTP Commands" -> "QUOTE", then in the box you would type SITE RUNXL. Using SITE is just like using QUOTE except it sends the word SITE before whatever you type. --Claude ----- Original Message ----- From: "Wiseman, Michelle" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 13, 2002 11:02 AM Subject: Excel and FTP > Claude, > Thanks for your response. I am definitely in the 'whole different kettle of > fish' > category. Here's the low down. I'm developing an automated FTP process to > integrate into our existing automated process for EDI. I'm using a batch > file to > open/execute WS_FTP (client)- then a client-side script runs to send a > current copy > of the excel spreadsheet to our WS_FTP Server. (Here's where I'm stuck) > I need to somehow write a client-side SITE command (using SHELL? or QUOTE?) > that will open the > Excel spreadsheet on the server. Can WS_FTP do that? > How does a client-side script command the FTP_Server to open the excel file? > After this excel sheet runs, I'm using a client-side script to do some more > stuff and > that's all working fine. It's just this one part I'm 'stuck on stupid'. > Thanks again. M > > Michelle Wiseman > Programmer/Analyst > State of Montana, > DLI/ERD/MSB > [EMAIL PROTECTED] > (406)444-3343 > > -----Original Message----- > From: Claude Edwards [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 12, 2002 5:48 PM > To: [EMAIL PROTECTED] > Subject: Re: [WS_FTP Forum] Excel and FTP > > > Using WS_FTP client, connect to your server, locate the file so it is listed > in the right (Remote) pane. Select the file, and press the "Execute" button > on the right pane. > > WS_FTP will download the file to a temporary directory on the client > computer and open it with the associated application. If it is an Excel > file, then Excel will open the file. If the file has code, then that code > may be executed, depending on how Excel is configured. > > Note that it is necessary for a copy of the file to be downloaded to the > client computer so that Excel running on that computer can open it. You can > use WS_FTP to download it to your local system and then use Excel to run it > from Windows, but the Execute button combines both actions. The file > remains unmodified on the server. Excel has to be on the client but not on > the server. > > If on the other hand, you have Excel on the server, and you want the client > to cause Excel to load the file and execute it on the server, that is a > whole different kettle of fish. Some FTP servers such as "WS_FTP Server" > have SITE commands that allow you to execute such commands on the server. > You would use the server configuration program to set up a SITE command that > executes your Excel file. Then use the client to connect to the server and > issue the SITE command. From WS_FTP right click on the remote pane and > select "Operations" then "FTP commands" then "SITE". > > > ----- Original Message ----- > From: "Wiseman, Michelle" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, December 12, 2002 6:30 PM > Subject: [WS_FTP Forum] Excel and FTP > > > > I have code in an excel spreadsheet on my ftp server. I want to use the > > ftp client to connect to the ftp server and > > open the excel file. The excel file will auto-execute the code and close. > > > > Any help is appreciated. Thank you. > > > > Michelle Wiseman > > Programmer/Analyst > > State of Montana, > > DLI/ERD/MSB > > [EMAIL PROTECTED] > > (406)444-3343 > > > > > Michelle Wiseman > Programmer/Analyst > State of Montana, > DLI/ERD/MSB > [EMAIL PROTECTED] > (406)444-3343 > > > > Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list.
