Running Access-to-Excel Automation....
 

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

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

Running Access-to-Excel Automation....
 

BEAUTIFUL.

Kevin - thank you.

Bob

"Kevin B" wrote:

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