Hello-
I have a spreadsheet named sheet, in a folder on the desktop called folder. In the folder there are 100 fixed length pdf file names. I would like to somehow have all the file names with extensions populated into the spreadsheet column A, beginning at cell A1.
I'm really not capable with VBA. Thanks for any guidance. J
1. You can't.
2. See attached file. Open & enable macros...
3. Select a cell where you want the list to start.
4. Press Execute.
5. Follow th einstructions.
6. If it's OK with you, I'll explain how to set it up... or you can simply use this file...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
(I like the pic; the scenery and food)
It worked beautify and easily! I'll review the macro and see what I can learn.
Thanks so much Glenn! J
If you have any problems, just shout. I'm hopeless with VBA. You have been warned.
Oysters and crevettes roses, on the Bassin d'Arcachon, SW France, 2018. Lovely area.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks