ZIP Excel File

[pr4t3ek]

Hi,
I save my excel sheet onto my desktop automatically using a code with a specific name + current date.
This works fine.
I then open up that xls file and extract data + import data to it etc..
Which works fine.

My question is, in the end how can i go about zipping that excel file to the same naming convention and same location where it is being opened from?

Thank You

[royUK]

What zip program do you have & which version of Excel are you using?

[pr4t3ek]

Excel 2003.
Winzip program

[royUK]

The full version of WinZip?

[pr4t3ek]

Yes full version.
WinZip Professional v11.1.7466 at home

in saying that, this will be used at work and i do not know which specific version at work, and won't find out until seven days away.

[pr4t3ek]

I save my excel sheet onto my desktop automatically using a code with a specific name + current date.
This works fine.
I then open up that xls file and extract data + import data to it etc..
Which works fine.

Is all done by a macro by the way, not manually

[royUK]

Look here

http://www.rondebruin.nl/zip.htm

[pr4t3ek]

cheers, i'll give that a go next week. thank you

[pr4t3ek]

I am getting the following pop-up box:
http://www.fileden.com/files/2007/8/...inzipPopup.JPG

when executing the following Zip code:

Please Login or Register  to view this content.

Any help?