Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteSpecial
I have a VB6 app that uses Excel to create spreadsheets. It needs to use
PasteSpecial with xlPasteValues extensively. Whilst the program is getting Excel to Copy / PasteSpecial, the users often inadvertantly use copy / paste in another application. This either causes junk in the Excel spreadsheet or junk in their other app. I would like to get around this problem, so is the a) a means of copying without use of the clipboard that will place values, not formulas in the destination cells (eg Range.CopySpecial (Dest, xlCopyValues) ), or b) a means of locking the clipboard for the duration of the few hundred Copy / PasteSpecial operations, or c) a means of stopping the user using the clipboard in other apps whilst the Excel routine is running, or d) any other idea that will overcome the problem? Many thanks, -- John Austin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PasteSpecial | Excel Programming | |||
PasteSpecial | Excel Programming | |||
pastespecial | Excel Programming | |||
pastespecial | Excel Programming | |||
pastespecial | Excel Programming |