Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello, I have some corrupt excel names in spreadsheets I'm sent from time to time. I can get rid of these via the nformation outlined in the Microsoft article: http://support.microsoft.com/default...b;en-us;555127 but I would like to "Automate" this. I know that there is a VBA Guru out there that can help me out. Perhaps you need to use the FindWindow API? Perhaps there is another way. Can someone send me some sample code that will automate this deletion process rather than having to delete every single corrupt name individually? Thanks Sam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete emty file names from "recent documents" Excel | Excel Discussion (Misc queries) | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
Delete "Unused names" in a batch | Excel Discussion (Misc queries) | |||
Delete All Names - Even Invalid "#REF" Names | Excel Programming | |||
Understanding: "BUG: VB Hangs While Automating Excel Using OLE Control" | Excel Programming |