Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
file names with full path
Hi Any help for a pull down list (validation)
can the names of active workbooks be listed with a pull down list at b5 in the active sheet called "Form 1" the list needs to be stored in active workbook, sheet name called "archive" from range c3 onwards.. like c3,c4,c5... each file name in following cells from c3. i have some related work, like using the sheet name at c5 some report has to be shown below. thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
file names with full path
Refer this link
http://www.mrexcel.com/articles/excel-user-forms.php -- If this post helps click Yes --------------- Jacob Skaria "Eddy Stan" wrote: Hi Any help for a pull down list (validation) can the names of active workbooks be listed with a pull down list at b5 in the active sheet called "Form 1" the list needs to be stored in active workbook, sheet name called "archive" from range c3 onwards.. like c3,c4,c5... each file name in following cells from c3. i have some related work, like using the sheet name at c5 some report has to be shown below. thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Names of workbooks - want relative, with no Full Path | New Users to Excel | |||
Novell server full path names of VBA references | Excel Programming | |||
Is it possible to get full file path in titlebar? | Excel Programming | |||
full path of excel file | Excel Discussion (Misc queries) | |||
Recurring Problems with Links with Full Path Names | Excel Discussion (Misc queries) |