| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing FTP through VBA Macro
Question: Is it possible to program a macro to 1) go to a ftp site 2) download a file 3) unzip that file? This sounds possible, but I'm going nuts but I don't know how to begin. I know that in excel you can go to Data|Import|New Web Query and find the file... however I don't know how to go outside of Excel and unzip the file. Has anyone seen anything like this before? Rob -- robsix6 ------------------------------------------------------------------------ robsix6's Profile: http://www.excelforum.com/member.php...o&userid=24045 View this thread: http://www.excelforum.com/showthread...hreadid=376564 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing FTP through VBA Macro
The simplest way is to use an external script to access the FTP and then run
the script through the SHELL function. See: http://support.microsoft.com/default.aspx?kbid=96269 -- Gary's Student "robsix6" wrote: Question: Is it possible to program a macro to 1) go to a ftp site 2) download a file 3) unzip that file? This sounds possible, but I'm going nuts but I don't know how to begin. I know that in excel you can go to Data|Import|New Web Query and find the file... however I don't know how to go outside of Excel and unzip the file. Has anyone seen anything like this before? Rob -- robsix6 ------------------------------------------------------------------------ robsix6's Profile: http://www.excelforum.com/member.php...o&userid=24045 View this thread: http://www.excelforum.com/showthread...hreadid=376564 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing FTP through VBA Macro
Hi robsix6,
You may want to have a look at this: http://www.bygsoftware.com/Excel/VBA/ftp.htm Regards, KL "robsix6" wrote in message ... Question: Is it possible to program a macro to 1) go to a ftp site 2) download a file 3) unzip that file? This sounds possible, but I'm going nuts but I don't know how to begin. I know that in excel you can go to Data|Import|New Web Query and find the file... however I don't know how to go outside of Excel and unzip the file. Has anyone seen anything like this before? Rob -- robsix6 ------------------------------------------------------------------------ robsix6's Profile: http://www.excelforum.com/member.php...o&userid=24045 View this thread: http://www.excelforum.com/showthread...hreadid=376564 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing FTP through VBA Macro
Hi again,
I also did something like this some time ago: 1) Create a *.txt file, say c:\Batch.txt 2) In the Batch.txt write the following script (change "ftp.server.com" the real FTP server, "UserName" to the real FTP server username, "Password" the real FTP acces password, "C:\MyFile.xls" to the name and directory of the file to be copied. Don't use quotation marks) : open ftp.server.com UserName Password send C:\MyFile.xls bye More info about switches he http://www.computerhope.com/software/ftp.htm#04 3) Run a code like this: Shell ("ftp -s:c:\Batch.txt") Reagrds, KL "KL" wrote in message ... Hi robsix6, You may want to have a look at this: http://www.bygsoftware.com/Excel/VBA/ftp.htm Regards, KL "robsix6" wrote in message ... Question: Is it possible to program a macro to 1) go to a ftp site 2) download a file 3) unzip that file? This sounds possible, but I'm going nuts but I don't know how to begin. I know that in excel you can go to Data|Import|New Web Query and find the file... however I don't know how to go outside of Excel and unzip the file. Has anyone seen anything like this before? Rob -- robsix6 ------------------------------------------------------------------------ robsix6's Profile: http://www.excelforum.com/member.php...o&userid=24045 View this thread: http://www.excelforum.com/showthread...hreadid=376564 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing FTP through VBA Macro
Others appear to provide a solution for the ftp question.
In terms of unzippng the file have a look at RondeBruin site http://www.rondebruin.nl/unzip.htm -- Cheers Nigel "robsix6" wrote in message ... Question: Is it possible to program a macro to 1) go to a ftp site 2) download a file 3) unzip that file? This sounds possible, but I'm going nuts but I don't know how to begin. I know that in excel you can go to Data|Import|New Web Query and find the file... however I don't know how to go outside of Excel and unzip the file. Has anyone seen anything like this before? Rob -- robsix6 ------------------------------------------------------------------------ robsix6's Profile: http://www.excelforum.com/member.php...o&userid=24045 View this thread: http://www.excelforum.com/showthread...hreadid=376564 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing FTP through VBA Macro
I have checked these sites out and famililarized myself with Batch file and the shell code, yet don't know how to finalize and execute the batc file from within the VBA... Is that self explanatory? Thanks for the hel -- robsix ----------------------------------------------------------------------- robsix6's Profile: http://www.excelforum.com/member.php...fo&userid=2404 View this thread: http://www.excelforum.com/showthread.php?threadid=37656 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Accessing macro from a system by all other nodes on LAN | Excel Discussion (Misc queries) | |||
| accessing outlook data using excel macro | Charts and Charting in Excel | |||
| Accessing workbook info from a different workbook macro | Excel Programming | |||
| Accessing a Hidden and Protected Workbook from a Macro?? | Excel Programming | |||
| Accessing worksheet cells from VBA macro? | Excel Programming | |||
Linear Mode
