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 > > > > > Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. > Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list.
