file names with full path

E

Eddy Stan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top