VBA .Add Cells - Set start Cell location <p>I need this VBA to pull all file names, Link them and place them in column A2 and down in +1 increments</p> <pre><code>Sub GetFileNamesInfolder() Dim FSO As Object Dim Folder As Object Dim File As Object Dim Path As String Dim A As Integer Path = "\\server5\Operations\MainBoard testing central location DO NOT REMOVE or RENAME" Set FSO = CreateObject("Scripting.FileSystemObject") Set Folder = FSO.GetFolder(Path) For Each File In Folder.Files A = A + 1 ActiveSheet.Hyperlinks.Add Cells(A, 1), File.Path, , , File.Name Next End Sub </code></pre> <p>how would you approach this?</p>