En cours

Excel 2010 Macro replace [url removed, login to view]

I have an excel with macro that:

1.) Column C value containts the directory the file that I am looking for

2.) search the directory in Column C for file in Column A.

3.) Save the file into a new Directory with the name specify in Column B

There is already a macro that is in the file that does that, just need that it uses Application.FileSearch.

which do not work in Excel 2010

looking for some to correct the existing macro: here is the macro below

Dim File_Name As Variant

Dim File_Save As Variant

Dim Folder_Name As Variant

Folder_Name = InputBox("What Folder Would you like to Save the CEAs in?")

Final_Row = Workbooks("Monthly Controllable Save.xls").Sheets(1).Range("A65000").End(xlUp).Row

For x = 1 To Final_Row

File_Name = Range("A" & x).Value

File_Save = Range("B" & x).Value

Dim i As Integer

With [url removed, login to view]

.LookIn = Range("C" & x).Value

'* represents wildcard characters

.Filename = Trim(File_Name) & "???????.xls"

If .Execute > 0 Then 'Workbook exists

For i = 1 To .[url removed, login to view]

[url removed, login to view] (.FoundFiles(i))

[url removed, login to view] Filename:= _

"b:\r p\OSUS\Monthly Analysis Folders\Monthly Analysis 2011\" & Folder_Name & "\Intl Monster\" & File_Save & ".xls"

[url removed, login to view]

Next i

End If

End With

Next x

Compétences : Excel

Voir plus : filesearch excel 2010, application filesearch excel 2010, excel 2010 filesearch, macro foundfiles 2010, macro excel 2010 filesearch, macro filesearch, excel 2010 macro filesearch, excel macro filesearch, excel 2010 macro file search, file search excel 2010, macro search file excel 2010, macro excel search replace, replace filesearch excel 2010, excel macro search replace work, excel filesearch macro, file search macro excel 2010, excel file search 2010 macro, macro application excel 2010, excel 2010 filesearch macro, excel file search macro 2010, file search excel macro, macro 2010 filesearch, excel 2010 foundfiles, application filesearch excel, excel 2010 macro application filesearch

Concernant l'employeur :
( 1 commentaire ) Murray, United States

N° du projet : #1672447

Décerné à :

Teloquence

Consider it done. Check your PM for my bid details.

150 $ USD en 1 jour
(49 Commentaires)
5.2