L
Lav
E.g. The macro is in workbook1.xls
I wish to copy cell B2
So Activeworkbook.Select
Dim Workbook1
Set Workbook1 = Workbooks.Add (or is it Open?)("C:Workbook1.xls")
Workbook1.Activate
Range("B2").Copy
?
I wish to copy cell B2
So Activeworkbook.Select
Dim Workbook1
Set Workbook1 = Workbooks.Add (or is it Open?)("C:Workbook1.xls")
Workbook1.Activate
Range("B2").Copy
?