VBA syntax to issue Refresh command

[MelissaGregory]

Hi all:

I am struggling in finding the method/syntax to issue a "Refresh" command in my VBA. Essentially, one worksheet in the workbook has a CONNECTION string defined in it that I want to be able to execute.

I do not want to use the RefreshAll option as I just need to have data refresh on this one worksheet and not the rest of the workbook

Can someone please help me out?

Thank you!

[ImStevenB]

Hi Melissa,

Have you tried

ActiveWorkbook.Connections("<connection name>").Refresh

That allows you specify a named Connection.

Hope this helps.

[MelissaGregory]

Thanks Steven - this worked like a charm!!!

[ImStevenB]

Happy to help

Don't forget to mark the thread as Solved