Unfortunately I haven't used VBA in several years. I used to know how to do
this. I have a folder where a daily report will be placed in the form of a
new Excel sheet every day. The only files in the folder will be these daily
reports. I want to monitor certain values on that report, so I need to
import the data from a few cells an put into a different spreadsheet. (Is it
easier for the "master file" to be in the same folder, or a different
folder?) The reports have Macro's and links, so when I open the file there
will be two popups (enable Macro, and update sheet). I don't need to enable
the Macro nor update the sheet. I need the data from cells B13 and B26 in
the report, put into columns for me to plot. Could someone help me out?
Also, the file names will indicate date or order. Will the files in the
folder be accessed in a specified order, or will I have to extract the data
from within the report?