Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Application.GetOpenFilename I can find what file the user would like
to open. But before opening I want to be sure the file isn't already open. Having the filename I can loop through the set of Application.Workbooks and check. Problem is the GetOpenFilename returns the full pathname, and Workbooks is a list of filenames only. So how do I easily extract the filename from the pathname? I looked around and could not find a function. If I have to I can loop through the name, find the slash (or colon), and do a Right. But I would think that there is an easier way. Thanks, Don <donwiss at panix.com. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup dynamic pathname | Excel Discussion (Misc queries) | |||
How do use listed pathname to link values from another workbook? | Excel Discussion (Misc queries) | |||
Using a dynamic pathname in VLOOKUP | Excel Worksheet Functions | |||
Full Pathname in Titlebar | Setting up and Configuration of Excel | |||
LoadPicture Pathname or no Pathname | Excel Programming |