Đang Thực Hiện

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

Kỹ năng: Excel

Xem thêm: 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, file search excel 2010, macro excel search replace, replace filesearch excel 2010, excel filesearch macro, macro application excel 2010, excel 2010 filesearch macro, file search excel macro, macro 2010 filesearch, excel 2010 foundfiles, application filesearch excel, filesearch macro, replace application filesearch, filesearch work excel 2010, filesearch excel 2010 macro, filesearch macro 2010, excel 2010 application filesearch, excel macro application filesearch

Về Bên Thuê:
( 1 nhận xét ) Murray, United States

Mã Dự Án: #1672447

Đã trao cho:

Teloquence

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

$150 USD trong 1 ngày
(49 Đánh Giá)
5.2