| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
| "Cannot access read-only document" (I get this error when I try to open an Excel file) | Excel Discussion (Misc queries) | |||
| why excel stops running?? | Excel Discussion (Misc queries) | |||
| automation from access into excel | Excel Discussion (Misc queries) | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
Threaded Mode
