| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting filename
Thanks Chaps
-- Cheers Nigel wrote in message oups.com... To get myfile.xls use:- FileNm = activeWorkbook.Name If it's the file extention you want (ie xls):- Extn = Right(ActiveWorkbook.Name, 3) Hope those work as haven't tryed them! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| set filename to <filename-date on open | Excel Worksheet Functions | |||
| & Filename | Excel Programming | |||
| Saving filename same as import filename | Excel Programming | |||
| extracting a stringvalue from filename | Excel Programming | |||
Threaded Mode
