Running Access-to-Excel Automation....
Add the following line above your paste command:
Application.DisplayAlerts = False
--
Kevin Backmann
"Bob Barnes" wrote:
Rarely, when this cose is run...
Range("DTop").Select
...Occurs directly below....
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
I get...
"Do you want to replace the contents of the destination cells?"
What causes this, & how can it be turned OFF?
TIA - Bob
|