Delay when updating a picture from excel to powerpoint

[ineona]

Hey,

I'm trying to copy a range from excel as a picture to Powerpoint while i'm viewing a different slide. In doing this I also format the picture to fit the picture using shape.top and shape.left. However, it seems that Powerpoint is executing my command until I get to the slide I'm trying to update. This results in a slide that resizes first thing when i get to the slide. It's not really a problem but I can't understand why it does this nor how to work around it?

Any suggestions are welcome!

Thanks in advance!

 

[mooseman]

If this is in a VBA subroutine, the you may need to wait until VBA has processed you command to copy/paste the range

Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Just call this in your code:

Sleep(3000)  '3 second delay for the macro

I use this a lot when the command takes PowerPoint (or Excel) a while to finish.