Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A bug in Excel 2007 causes the name immediately following Print_Titles to
disappear from a workbook after Application.Run has called a routine in the workbook, then the workbook is closed and reopened. TO REPLICATE: Create 2 workbooks: Master.xlsm and Slave.xlsm In Slave.xlsm, do two things: 1) Name a range QQQ (such that it follows Print_Titles) 2) Create a VB macro called NoOp that does nothing. In Master.xlsm: 1) Create a VB macro that does: Application.Run "'Slave.xlsm'!NoOp" Now, close Slave (with or without saving it), keeping Master open. Reopen Slave, and the first name following Print_Titles cannot load. It's in the file, but not in the name manager when the file is loaded. WORKAROUND: Always ensure there is a name Print_Titles_ZZZZZZ, replace if missing on WorkbookOpen. QUESTION: Is there any other damage caused by this bug that I haven't discovered yet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Execute a Macro from one excel Application to another Application | Excel Programming | |||
difference application.quit & application.close | Excel Programming | |||
Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming |