Hi all,
I have a macro, which reads a directory (C:\logs\*.log) and creates worksheets in the name of log files dynamicaly in a lopp with
MyFile = Dir("C:\logs\*.log"), and i have a predefined worksheet called Report... I just want to make some calculations in these created sheets and put the results in to the predifined sheet but just open a browse windows to choice the file "MyFile"... In fact "MyFile" is just a variable that keeps the name of the sheets.
Worksheets("Report").Cells(5, 2).Value = "=Average(MyFile!B1:B300)"
Any thoughts?
I have a macro, which reads a directory (C:\logs\*.log) and creates worksheets in the name of log files dynamicaly in a lopp with
MyFile = Dir("C:\logs\*.log"), and i have a predefined worksheet called Report... I just want to make some calculations in these created sheets and put the results in to the predifined sheet but just open a browse windows to choice the file "MyFile"... In fact "MyFile" is just a variable that keeps the name of the sheets.
Worksheets("Report").Cells(5, 2).Value = "=Average(MyFile!B1:B300)"
Any thoughts?