VBA macro help reflection workspace

[manojxls]

Hi,

When I running below code works fine
ExcelApp.activesheet.range("b2").copy

But below code shows error as (object doest support this property or method)
ExcelApp.activesheet.range("j2").paste

Please help

 

[mikerickson]

Ranges do not have a .Paste method, it is a method of a worksheet object.

Try

With ExcelApp.ActiveSheet
    .Range("B2").Copy Destination:= .Range("J2")
End With

 

[manojxls]

Ranges do not have a .Paste method, it is a method of a worksheet object.

Try

With ExcelApp.ActiveSheet
    .Range("B2").Copy Destination:= .Range("J2")
End With

Yes your code works good in copy from excel to excel.

But my problem not solved

I have code
ibmCurrentScreen.SetSelectionStartPos 8,62
ibmCurrentScreen.ExtendSelectionRect 8,70
ibmCurrentScreen.Copy

Above 3 line code works correct
But the copy number for not paste In cell j2

Want to paste number from IBM reflection terminal to excel.

Please suggest

 

[mikerickson]

I don't know what an IBM reflection terminal is. The naming of the variable ibmCurrentScreen suggests that more than a number is being copied.

 

[manojxls]

I don't know what an IBM reflection terminal is. The naming of the variable ibmCurrentScreen suggests that more than a number is being copied.

From terminal 9 digits number is copied that i can see in clipboard that works correct

Any way I can copy from terminal to excel

 

[mikerickson]

This will take text from the clipboard and put it in a cell

Dim objDataobject As DataObject
    
objDataobject.GetFromClipboard
Range("A1").Value = objDataobject.GetText

 

[manojxls]

Showing error complier error
User defined type not defined

 

[shg]

Set a reference to Microsoft Forms Object Library.

Or add and then delete a userform, which will do the same thing.

 

[manojxls]

Set a reference to Microsoft Forms Object Library.

Or add and then delete a userform, which will do the same thing.

Shg can share me code

 

[shg]

No code.

From the VBE, Tools > References, find and tick Microsoft Forms Object Library.