Adam has attended:
Access Advanced course
Access Intermediate course
Excel VBA Intro Intermediate course
A loop for opening files
Hi
I have a huge database that needs refreshing on a timely fashion.
As it is linked to many identical files that differ only by part of the name I need help on the following:
I need a loop that will open a file based on the location and file name provided in the relevant set of rows. in other words, for rows 10-100 open the file XXX refresh the links and the close the file. then go to rows 101-175 and do the same.....
I want the code to identify that if there is a change in the file name, it should close the old linked file and open the new relevant file to continie refreshing.
THX
Adam
RE: a loop for opening files
Hello Adam
Thanks for your post. We have reviewed this and think we can assist but will need to look at your working files. As this does fall outside the capacity of the forum we are looking at 2-3 hours minimum of work to reach a solution which will be chargeable.
We would notify you of scope of work including durations and costs before proceeding.
If you would like to investigate this option further please let us know.
Kind regards
Jacob
