Ensuring that VBA code runs on records in a targeted Excel Worksheet

Hello,

I am running the following code (below) that is working great with one exception - if I am not specifically on the 'Webstats_RptList_RawData' tab in the active Workbook, the code will not bring in the latest records from the OneDrive folder that the target Excel files reside in it. How do I adjust the code to ensure that the 'Webstats_RptList_RawData' tab is the 'active' tab so that the code grabs the latest records from the target OneDrive folder and does not merely refresh the records already present in the 'Webstats_RptList_RawData' tab?

Please Login or Register  to view this content.

Yes - I gratefully stand on the shoulders of the giants who came before me. The code above looks to have done the trick and thank you!