djl0525
Well-known Member
- Joined
- Dec 11, 2004
- Messages
- 1,240
I've got this simple query that works fine except it prompts me to replace the contents of the cells. I click Yes. How do I suppress this prompt, please?
Thanks -- DJ
Sub RefreshDJL()
'
' RefreshDJL Macro
' Macro recorded 6/27/2006 by DJLEE
'
'
Range("A1").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Application.Run "'final 5 DJL.xls'!tavve"
End Sub
Thanks -- DJ