i have a coloumn "ID" which contains ID . in the next coloumn i want to get the name of the folder which contains a word file with same name as ID.
can any one help me with this(excel formula or Macro) any thing will be ok.
thanks
i have a coloumn "ID" which contains ID . in the next coloumn i want to get the name of the folder which contains a word file with same name as ID.
can any one help me with this(excel formula or Macro) any thing will be ok.
thanks
So for example, you have the ID 1234ABC
You want Excel to search your computer for a Word file called 1234ABC.DOC(x)
and return the folder that that file is in?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
yes exactly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks