I need to parse multiple files in .XLSX
that are in several folders and generate the data graphs, all .xlsx
files have the same amount of rows and columns in a spreadsheet with a specific name.
I've created another file so that I can copy and paste the data and the graphics are generated automatically. I wanted to select a file through a list and the data would be read by my graphics file.
I have tried vlookup
but I can not make the folder choice where the files are.
I was able to modify a VBA, which is described below, but it does not modify the formula in cells.
Sub FindReplaceAll_CountReplacements()
'PURPOSE: Find & Replace text/values throughout entire workbook, notify user of how many cells were affected
'SOURCE: www.TheSpreadsheetGuru.com
Dim sht As Worksheet
Dim fnd As Variant
Dim rplc As Variant
Dim ReplaceCount As Long
fnd = Range("F3").Text
rplc = Range("F2").Text
For Each sht In ActiveWorkbook.Worksheets
ReplaceCount = ReplaceCount + Application.WorksheetFunction.CountIf(sht.Cells, "*" & fnd & "*")
sht.Cells.Replace what:=fnd, Replacement:=rplc, _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
SearchFormat:=False, ReplaceFormat:=False
Next sht
MsgBox "I have completed my search and made replacements in " & ReplaceCount & " cell(s)."
End Sub