For weeks now I've had a lot of trouble with refreshing query tables. As best as I can tell, my vba usually sticks on the following code:
I refresh my connection first and then I refresh my query table. Above is the way I've been told to do that. Sometimes it works, sometimes it doesn't and I can't tell why.
Is there a better way?
VBA Code:
Sheets("Acknowledgements").ListObjects("q_Acknowledgements").QueryTable.Refresh BackgroundQuery:=FalseI refresh my connection first and then I refresh my query table. Above is the way I've been told to do that. Sometimes it works, sometimes it doesn't and I can't tell why.
Is there a better way?
