Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"Troubled User" wrote in message
... [...] 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. Just an ideat at 02:30 AM. Try putting a DoEvents between the two procedure calls. Bruno |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
can you load the picture and then print the letter in the same macro
instead of calling 2 separate macros?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Advancing Timing | Excel Discussion (Misc queries) | |||
Timing Issue?? | Excel Programming | |||
Timing Chart | Charts and Charting in Excel | |||
VB timing question | Excel Programming | |||
Program timing | Excel Programming |