Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes, I'm calling it from the Workbook_BeforePrint event.
And yes, Application.Build on my system returns 8216. Thanks for your testing: as all of our systems have been updated with the latest patches, there's no way to do the comparison here. Thanks! And thanks for passing this information along to MS! -----Original Message----- You're calling this macro from the BeforePrint event? If so I have the exact same problem. Calling it normally there is no problem. I'm running Excel 2000 SP3 with the November 2003 Security Patch (K830349) installed. The only way you can tell if you have it installed is to run Application.Build. This will return "8216" if this patch is present. SP3 by itself returns "6627". I tried this code in the BeforePrint event on a coworker's machine which had SP3 but no security patch. It was fine. So it may be that this patch introduced a bug. I'll pass this on the MS but I don't have a solution other than the one you found. -- Jim Rech Excel MVP . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert ThisWorkBook.FullName as Link in Email | Excel Discussion (Misc queries) | |||
Seperating Text in One Field into 2 Fields EG FullName | Excel Discussion (Misc queries) | |||
ActiveWorkBook | Excel Discussion (Misc queries) | |||
ActiveWorkbook.RefreshAll | Excel Programming | |||
Looking for Excel function to resolve userid to fullname. | Excel Programming |