PasteSpecial

[John Austin]

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 there:
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,

 

[Charlie]

Why do you need to use copy/paste? In your VB app you can get and put
two-dimensional data like this:

Dim RangeGrid() As Variant
RangeGrid = Range("A1:Z26")
(code here to modify data as necessary in 2D-array)
Range("Sheet2!A1:Z26").Value = RangeGrid