P
Pat
I am trying to automate a process that I must do repeatedly. I need to
copy certain information from many different files into one excel
file. I have a list of the files names that I need to open and I
planned on opening that file (filenames.xls), look at the first cell
where the first file name is stored, assign that to some variable and
then open that particular filename. I would like to copy certain
information from the file (which will be in the same location for all
proceeding files) just opened to a temp.xls and then close the file.
The macro then would go back to the filenames.xls, go to the next
cell, store the next filename, open that file, copy info to temp.xls
and then close that file. Repeat these steps until the cell range = ""
in filename.xls. I am a newbie when it comes to automating functions
and ususally rely heavily on "Record a New Macro" function to help me
out but this can't really help me in this case. Is there anyone that
can help me out.
Pat
copy certain information from many different files into one excel
file. I have a list of the files names that I need to open and I
planned on opening that file (filenames.xls), look at the first cell
where the first file name is stored, assign that to some variable and
then open that particular filename. I would like to copy certain
information from the file (which will be in the same location for all
proceeding files) just opened to a temp.xls and then close the file.
The macro then would go back to the filenames.xls, go to the next
cell, store the next filename, open that file, copy info to temp.xls
and then close that file. Repeat these steps until the cell range = ""
in filename.xls. I am a newbie when it comes to automating functions
and ususally rely heavily on "Record a New Macro" function to help me
out but this can't really help me in this case. Is there anyone that
can help me out.
Pat