I want to know if there is a way to set multiple files to open, refresh,
save, and close. I have 38 files that need to refresh when I update my
Access database.

#1 We've set the files to NOT refresh upon opening for control purposes.
Evidently there's been problems with this in the past.
#2 I've already tried a macro but when I run it Excel tries to save before
the refresh is complete.
#3 So basically I want a "go button", something I can kick-off and it will
go through all 38 files and do the refreshes. I know a little SQL and my
co-worker knows a little VBA.

Thanks in advance for your help.