VBA Calling the Wrong Workbook

[Michael515]

Hi Y'all,

At my job we work with multiple workbooks that are created from pulling data from a database. Every one of these workbooks have a refresh button that refreshes the workbook (all straight forward enough so far haha). I have made created a workbook (lets call it workbook A) that refreshes itself at certain times and saves itself to a certain shared drive. However, if I'm in any other workbook that has the same refresh button, lets call this workbook B, at the designated time, the call function for workbook A, refreshes workbook B instead of workbook A, and saves workbook B to the shared folder. What I ideally want to happen is to open workbook A at the beginning of the morning, have it refresh itself at 4 designated times during the day, and then close itself at the end of the day, meanwhile I'd be working on workbooks B, C, D etc. throughout the day. I originally though I had the VBA written right, but in today's demo run, when Workbook B was open during the designated time to refresh and save workbook A, workbook B refreshed and saved and not workbook A. Is there any way to have this refresh button (which is common in all the workbooks we work with), only refresh workbook A and NOT the active workbook?

I hope I explained the problem well enough. If you have any questions let me know. Thanks ahead of time for all your help!

 

[CalcSux78]

Hard to tell what's wrong when we can't look under the hood.... Look into how your refresh command is called. Did you declare as:

ThisWorkbook.Connections("connection1).Refresh

At a minimum, declare which workbook the connections belong to that you are refreshing.