Hello GS (again)
If you don't need the actual code then my free Excel add-in "List Files"
does what you want and it is very easy to use.
You can download it from here...
http://www.realezsites.com/bus/primitivesoftware
Regards,
Jim Cone
San Francisco, USA
"Gary''s Student"
wrote in message
What is the easiest way to import hyperlinks into a worksheet using VBA?
For example if a folder (say Favorites) contains 100 hyperlinks (shortcuts),
I would like to populate a column of 100 cells each containing a hyperlink
with the appropriate Address and TextToDisplay.
--
Gary's Student