Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: LandoMarossi
- Order by date
-
VBScript To copy the specific columns only to specific cell in Excel 365
Thanks a lot! Now working correctly.- LandoMarossi
- Post #7
- Forum: VBScript
-
VBScript To copy the specific columns only to specific cell in Excel 365
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 =...- LandoMarossi
- Post #5
- Forum: VBScript
-
VBScript To copy the specific columns only to specific cell in Excel 365
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 =...- LandoMarossi
- Post #3
- Forum: VBScript
-
VBScript To copy the specific columns only to specific cell in Excel 365
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...- LandoMarossi
- Thread
- Replies: 7
- Forum: VBScript
