Hi Everyone,
I am at initial stage of learning VBA Macro
I need small help to get file names from a particular assigned folder and i tried below coding its not working and i am unable to understand why its not working.
can anyone please help me in this and i need this steps for cumulating purpose.
Please Login or Register to view this content.
Thanks in Advance !
MNR.
Moderator's note: Don't forget to put code tags around your codes. thanks.
Last edited by vlady; 11-07-2012 at 03:05 AM.
put in B2 the folder to be scanned tlike C:\test, the change line Cells(mrow, 5).Select to Cells(mrow, 5).Value = fdr
If solved remember to mark Thread as solved
Re: Need File Name from a particular assigned folder path.
Thanks alot sir,
its working very nicely ur correct instead of mention cells(mrow,5).select and i used ur code cells(mrow,5).value = fdr.
Once again thanks & today i learn new thing here.
one more thing sir how to make this thread got solved.
Thanks,
Naveed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks