I have a macro (call it TheFinalPrintMacro) that calls two other macros:
(call them (LoadPicture) and (PrintLetter)
The first macro (LoadPicture) changes out the image in Image1 on Sheet1,
based upon the selection in a drop list. This macro works fine on its own.
The second macro (PrintLetter) simply prints a portion of the the page
(Sheet1) that contains, among other things, the image in the first. This
macro works fine on its own.
TheFinalPrintMacro simply consists of calling the other macros in order:
Sub FinalPrintMacro
LoadPicture
PrintLetter
EndSub
The problem is that the letter is printing before the picture has been
loaded and I DON'T KNOW WHY. I don't know if I need to have the system
wait a couple of seconds or verify that it has completed the LoadPicture
function before calling PrintLetter. Please help.
Bookmarks