macro to change links????

[cmefly]

Hi,

i've got a spreadsheet with a bunch of formulas.

At the moment, it's linked to a file within a folder called c:\profiles.

There are 40 files in this directory.

i need a macro that will change the link in my spreadsheet to each file within the directory...and save the file as "profile_links1", "profile_links2", etc.

any ideas?

 

[cmefly]

Bump

 

[cmefly]

okay, here are some more details:

here is my macro: my question is located in the starred section

Sub openAllfilesInALocation()

Dim i As Integer
Dim wb As Workbook

Application.ScreenUpdating = False

With Application.FileSearch
.NewSearch
.LookIn = "G:\Profiles"
.SearchSubFolders = False
.Filename = "*.xls"
.Execute

For i = 1 To .FoundFiles.Count
'Open each workbook

Application.DisplayAlerts = False
'*********************
'AT THIS POINT, HOW DO I GET THE NAME OF THE FILE (i) AND ASSIGN IT TO A VARIABLE??????

'*********************************
Set wb = Workbooks.Open(Filename:=.FoundFiles(i))

'Perform the operation on the open workbook
larger_macro

'Save and close the workbook
wb.Save
wb.Close
'On to the next workbook
Next i
End With

Application.ScreenUpdating = True


End Sub

 

[cmefly]

Bump

 

[cmefly]

Bump

 

[cmefly]

Bump....

Please help!

 

[cmefly]

Can some please have a look at this ? really need the help