A routine that Zips any number of files (by default it starts out with file extension = .xls) via a user selection and emails the zipped workbook.
The routine uses API calls to monitor the Zip process (shell & wait), so it can wait for it to finish and then create the email with the attachement AFTER it has finished zipping the file. This is better then just setting a wait timer as the time paused can vary depending on your PC and the number of processes running (your resources).
My thanks to Xl Dennis for pointing out a problem with names that have spaces and to Richie(UK) for the fix, always pays to TEST under ALL conditions!!
My thanks to Mark O'Brien for alerting me to the frustrating fact that the code pages do NOT copy, if at all
![Goto Guest book sign in page [Home]](files/guestbook.gif)
