blckngldhwk
Technical User
For whatever reason I'm having a block and can't figure out how to paste information that I have copied from Extra into a cell in Excel. Keep in mind, I'm not able to do this as a string, I am using the MyArea.Copy function and need to paste that into Excel.
What's next?
Code:
Set MyArea = MyScreen.Area(18,02,21,80)
MyArea.Select
MyArea.Copy
file = "H:\Macro Team\M201 Project\testbook1.xlsx"
Dim obj as object
Dim objWorkbook as object
Set obj = CreateObject("Excel.Application")
obj.visible = True
obj.workbooks.open file
set objworkbook = obj.worksheets("Sheet2")
With obj.worksheets("Sheet2")
.Cells(1,"B").activate
What's next?