Thanks.
I've tried your code.
I've the same error
Object Doesn't Support this Property or Method
on the same line
objWorkbook2.Worksheets(1).Range("M4").Paste
Your complete code
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook =...
Hi, thanks for reply.
I have edit my code, but now I have error
Object Doesn't Support this Property or Method
on this line
objWorkbook2.Worksheets(1).Range("M4").Paste
My new code below
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook =...
Hi,
I'm trying to copy specific column values (range "M:P") from one excel 365 file to the other on the range "M:P", using VBScript.
Master.xlsx file structure
Copy_2022.xlsx file structure (after the copy columns from Master.xlsx)
The copy of specific column values working correctly from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.