I am having difficulties with an excel/powerpoint connection.
Both have a timed macro running, but both macro's acces the same excel database.
As expected they run in to each other, and the powerpoint shuts down it's presentation due to the database being read only.
I have tried having both macro's checking the file for being read only, this goes well with excel.
Powerpoint shuts down the database after every update, and then it doesn't check anymore.
So far the issue, now the solution i am looking for:
Both macro's run every 10 minutes, but the ppt macro is so slow it is caught by excel.
So is there a way to tell the macro's to run on X:05 -> X:15 -> X:25 -> etc.
The other one i will run than at X:00 -> X:10 -> X:20 -> etc
This why it doesn't matter the ppt macro takes 2 min.
will work, but takes 6*24 lines of code a macro.
Example files can be supplied, but didn't think they would be needed.
with kind regards