Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dick Krusleika, has an add-in, favorites.xla that adds a favorite list
to the File Menu. It limits the list to 9 files, which I have changed to 15 files and thus, this line in the add-in fails to open any files 10 - 15: With CommandBars.ActionControl 'Try to open the file sCap = HandleAmp(Right(.Caption, Len(.Caption) - 3), _ False) On Error Resume Next Set wb = Workbooks.Open(sCap) On Error GoTo 0 I need an or statement, such as: Or sCap = HandleAmp(Right(.Caption, Len(.Caption) - 4), False) but it doesn't work. How do I make it work? TIA Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Favorites | New Users to Excel | |||
What's your favorites? | Excel Discussion (Misc queries) | |||
favorites | Excel Discussion (Misc queries) | |||
Favorites in Excel | Setting up and Configuration of Excel | |||
Adding to Favorites | Excel Programming |