Workbooks.Open Filename:="C:\Export\Safeacc.xls"
Columns("A
"
.Select
Selection.Copy
Windows("testing4.xls"
.Activate
Columns("A
"
.Select
ActiveSheet.Paste
runtime error1004 select range method of class failed
I'M SURE THIS USED TO WORK BUT NOT ANYMORE. i HAVE IT SO THAT YOU CLICK A BUTTON AND IT OPENS AND COPIES DATA FROM A-D COLUMNS IN ONE FILE TO THE OTHER WHERE THE PROGRAMED BUTTON IS.
Columns("A
Selection.Copy
Windows("testing4.xls"
Columns("A
ActiveSheet.Paste
runtime error1004 select range method of class failed
I'M SURE THIS USED TO WORK BUT NOT ANYMORE. i HAVE IT SO THAT YOU CLICK A BUTTON AND IT OPENS AND COPIES DATA FROM A-D COLUMNS IN ONE FILE TO THE OTHER WHERE THE PROGRAMED BUTTON IS.