FTP From Excel?

Andy Gee · Apr 11th, 2002, 02:39 PM

Can I ftp from Excel?
From either a compiled file (preferred)
or
The contents of a cell

To an html page on the net.

Is there an ftp command burried deep within the depths of Excel's plethora of functions?
or
Can I get excel to launch a dos or windows based ftp command?

Any help may get me a pay rise!

Jack in the UK · Apr 11th, 2002, 02:52 PM

i might be tempted to save excel as html and pen in FTP and work from there...

Andy Gee · Apr 11th, 2002, 02:57 PM

I would also, but it's for a friend to update their website and they have virtually no pc experience. Is there a way I can launch a separate program from Excel? This would be enough!

Jack in the UK · Apr 11th, 2002, 03:12 PM

ERmm

which office program do you want to open, or if thisis the case what about upload the excel wkbk and get the hyperlink to open the sheet via IE (DHTML)

that way edit and up load just excel... job done...

any good.

Andy Gee · Apr 11th, 2002, 03:28 PM

I don't need to upload a whole sheet, just some html and javascript, compiled through excel. The excel file is at http://www.hungrybear.co.uk/compile.zip if you want to have a look?

Andy Gee · Apr 11th, 2002, 04:16 PM

Got it!

Dim RetVal
RetVal = Shell("C:FTPIT.bat", 1)

FTPIT.bat has the commands to ftp the file to my server!

Presto Hey!

Apr 11th, 2002, 02:52 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	i might be tempted to save excel as html and pen in FTP and work from there... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 11th, 2002, 03:12 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	ERmm which office program do you want to open, or if thisis the case what about upload the excel wkbk and get the hyperlink to open the sheet via IE (DHTML) that way edit and up load just excel... job done... any good. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 02:39 PM	#1
Andy Gee New Member Join Date: Feb 2002 Posts: 48	Can I ftp from Excel? From either a compiled file (preferred) or The contents of a cell To an html page on the net. Is there an ftp command burried deep within the depths of Excel's plethora of functions? or Can I get excel to launch a dos or windows based ftp command? Any help may get me a pay rise!

Apr 11th, 2002, 02:57 PM	#3
Andy Gee New Member Join Date: Feb 2002 Posts: 48	I would also, but it's for a friend to update their website and they have virtually no pc experience. Is there a way I can launch a separate program from Excel? This would be enough!

Apr 11th, 2002, 03:28 PM	#5
Andy Gee New Member Join Date: Feb 2002 Posts: 48	I don't need to upload a whole sheet, just some html and javascript, compiled through excel. The excel file is at http://www.hungrybear.co.uk/compile.zip if you want to have a look?

Apr 11th, 2002, 04:16 PM	#6
Andy Gee New Member Join Date: Feb 2002 Posts: 48	Got it! Dim RetVal RetVal = Shell("C:FTPIT.bat", 1) FTPIT.bat has the commands to ftp the file to my server! Presto Hey!