Using Indirect in VBA to Refresh Individual Queries

[AdamLeonardo]

Hi All,

I need help with a project I'm working on and am not well versed using Visual Basic. I've developed a workbook that draws data from several other workbooks and uses queries to populate the worksheets. It's got 80 queries that can be refreshed as needed, but they don't all change data every day and if I refresh all, it takes a while to load everything. I'd like to be able to list which queries I'd like to refresh and use a macro to only refresh those. The first query number is listed in cell A3 and will change everyday. I don't know how to use an indirect type of equation in VBA. Can anyone help me figure this out? Thanks!

 

[steve the fish]

Something like:

ActiveWorkbook.Connections(Range("A1").Value).Refresh

Use the macro recorder to see what you need to type in the cell.

 

[AdamLeonardo]

Thank you Steve! That worked perfectly.