Thanks mate..
It works
Harpreet Gujral
On Mon, Mar 8, 2010 at 12:58 PM, rf1234 rf1234 wrote:
> Dear gurpreet
> Have a look on following code.
>
>
Dear gurpreet
Have a look on following code.
''
Option Explicit
Sub Copy()
Dim wb As Workbook
Dim ws As Worksheet
Hi Group,
I have to copy a range of cells from anotherworkbook to activeworkbook,
without opening the workbook.
Example: I have the activeworkbook present in
C:\ Temp1\XXX\YYY\Book1.xls
while the other workbook resides at the following
C:\Temp2\XXX\YYY\Book2.xls
I have to copy Contents of sheet2
