B
bondcrash
Hi all,
I am trying to have Excel pull out into one or more cells the name an
extension of ALL the workbooks open
I have found two ways but none is completely satisfactory so far:
- builda user form: shows the names but I cant find a way to paste the
into cells
-used the following formula, which only shows the last used workboo
within excel and not whatelse is open
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)
Has anyone come across something like that before?
Many thanks
B
I am trying to have Excel pull out into one or more cells the name an
extension of ALL the workbooks open
I have found two ways but none is completely satisfactory so far:
- builda user form: shows the names but I cant find a way to paste the
into cells
-used the following formula, which only shows the last used workboo
within excel and not whatelse is open
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)
Has anyone come across something like that before?
Many thanks
B