K
Keith
I have created a macro to dump data from 12 different
queries in MS Access into 12 different Excel files. That
part works great.
I have another Excel file (in the same folder) that is
linked to each of these files. However, it will not read
the updated info in these files unless I manually open
each of the 12 files. What do I need to do to to make my
Excel file read the data from the 12 files without opening
each of the files?
Thank you.
queries in MS Access into 12 different Excel files. That
part works great.
I have another Excel file (in the same folder) that is
linked to each of these files. However, it will not read
the updated info in these files unless I manually open
each of the 12 files. What do I need to do to to make my
Excel file read the data from the 12 files without opening
each of the files?
Thank you.