Thread: copy data when enter the file name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
new_to_vba[_7_] new_to_vba[_7_] is offline
external usenet poster
  
Posts: 1
Default copy data when enter the file name

i have 6 files in One Folder, Resource, Pt1, Pt2, Pt3, Pt4, Pt5.

i need to copy the specific data from the 5 files Pt1,Pt2, Pt3, Pt4,
Pt5 when i enter the containing text of the FileName into the file
Resource,
example entering Pt in the spaces provided under the file Resource, and
it will copy all the data from the 5 files (Pt1, Pt2, Pt3, Pt4, Pt5)
into Resource.

this seems impossible..i have no idea how to get it done..


--
new_to_vba
------------------------------------------------------------------------
new_to_vba's Profile: http://www.excelforum.com/member.php...o&userid=30131
View this thread: http://www.excelforum.com/showthread...hreadid=509263

Reply With QuoteReply With Quote