I have a macro which runs a Power Cube which then converts into a Powerplay report. This in turns uses an Excel spreadsheet to email the results to a specific person on the network.
My problem is when the macro completes, Excel returns a message stating the spreadsheet with the email addresses on is "available for editing". Occasionally it will also keep emailing the same document results until the pwrplay.exe process is killed.
How can I stop the message and how can I stop the duplicate emails ? I can forward the macro used if necessary.
Thanks.
My problem is when the macro completes, Excel returns a message stating the spreadsheet with the email addresses on is "available for editing". Occasionally it will also keep emailing the same document results until the pwrplay.exe process is killed.
How can I stop the message and how can I stop the duplicate emails ? I can forward the macro used if necessary.
Thanks.
