Hi!Need to read data from file #1 to file#2.
Way I am doing it now is:
Code
'open the file as active file
Workbooks.Open Filename: = "Full Path to the File"
'Do whatever should be done.. calculations, filtering, formatting
'...
'Close File
ActiveWindow.Close
This way file is remained opened( active) while reading is done...
I was wondering if there is a way to read data from the file without visually opening it?
j.v.a.