Posts by falcios

Re: Create hyperlinks to all files in a folder-how to modify code found on site

I've tried a few times to delete column A and it's not working. What do I need to add to current code to remove column A after it finishes adding all the hyperlinks?

Quote from cytop;778299

Then why not just add a single line to the existing code to delete column A when it finishes?

Re: Create hyperlinks to all files in a folder-how to modify code found on site

For example, if I use c:\folder\folder1\folder2 as the path, in column A1 it will start with c:\folder, column B1 will have c:\folder\folder 1 and column 2 c:\folder\folder1\folder2. I always end up deleting column A1/the top folder because there are no links.
I was looking for VBA code to give me the hyperlinks of the folder path but to start with c:\folder\folder1 in A1 and so on.

Quote from cytop;778272

What do you mean by "No top folder"...?

The listing has to start from somewhere.

It does list the files into Column A.

http://www.ozgrid.com/forum/showthread.php?t=175318

I came across this VBA code on this site on how to create hyperlinks to a particular folder. Is there a way to modify so that there is no top folder and it starts listing files in column A?

Thanks in advance.

Re: File and Folder Index with Hyperlinks

This VBA code is very useful. How can it be changed to start hyperlinks list in column A and not include top folder? Thanks