PasteSpecial

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
Back
Top