Excel to Zipped???

[hce]

Hi

I have a macro which helps me to send specified files to specifie
recipients... Now I am working on another one which would help me t
zip the specified excel files to specified zip files... but i am no
able to do it...

What I have in mind is that say I have an excel file i
k:\test\help\hello_aug'04.xls and I would like to zip it a
k:\test\help\hell0.zip... Is this possible to do it in Excel?

Another thing I would like to explore is to write a macro to upload th
"zipped" file or specified files to my website without me starting ft
and manually dragging the files over... Is this possible to do i
Excel...? so that I can specify the filenames n they would
uploaded...

Any help or suggestion would really be appreciated!!!

Cheers
kelvi

 

[hce]

Hi

I managed to figure out how to zip the Excel files but still unable t
figure how I can upload the files via Excel & FTP...

In addition, can anyone provide any suggestions on how I can renam
filename just by using vb code to write a macro to do it...? say th
original filename exists on A1 and I want the macro to rename the fil
to what's on A2...

I figured a way out and that is to open the file save as the new fil
name then delete the "ole" one... However, this way is taking to
long... n it's pretty risky... so does anyone have any better idea...?

Cheers
kelvi

 

[Harald Staff]

Hi Kelvin

Renaming is very easy:

Sub test()
Name "C:\Temp\Test1.mp3" As "C:\Temp\Scream.mp3"
End Sub

FTP I dunno, sorry.

HTH. Best wishes Harald

 

[hce]

hi harald

Thanks... it's perfect... no worries on the ftp... i m still working o
it... hopefully can get a solution soon...

cheer

 

[Dave Peterson]

You could search Google for FTP procedures--you'll find lots. Some use windows
APIs.

Here's a version I use that uses the FTP that comes with windows.

http://groups.google.com/[email protected]