Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 151
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8,520
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Names of workbooks - want relative, with no Full Path Gdareos[_2_] New Users to Excel 1 April 21st 08 12:08 AM
Novell server full path names of VBA references Nicholas Dreyer Excel Programming 8 October 24th 06 07:50 AM
Is it possible to get full file path in titlebar? screenwriter Excel Programming 1 September 26th 06 05:11 PM
full path of excel file Song Excel Discussion (Misc queries) 2 August 21st 05 06:50 PM
Recurring Problems with Links with Full Path Names JMcBeth Excel Discussion (Misc queries) 1 February 4th 05 11:11 PM


All times are GMT +1. The time now is 01:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"