Hi,
I'm currently trying to zip and password protect an excel file I output on a monthly basis so I can then auto email it to the relevant recipients.
I've tried playing around with DDE and a few other bits I've found on the internet, but, to no avail :-(
Does anyone have any idea how to do this? and if it is possible without the use of DDE?
If the file can't be zipped then just a passworded Excel file would be sufficient...
Thank you loads for any advice you may have
I'm currently trying to zip and password protect an excel file I output on a monthly basis so I can then auto email it to the relevant recipients.
I've tried playing around with DDE and a few other bits I've found on the internet, but, to no avail :-(
Does anyone have any idea how to do this? and if it is possible without the use of DDE?
If the file can't be zipped then just a passworded Excel file would be sufficient...
Thank you loads for any advice you may have