Copying data without opening the workbook

Hi All,

Is there a way in which I can copy data from some named ranges in a excel
workbook without actually opening it. I have to do it through VBA. The idea
is to get the data from a file into the file which is running the VBA code.

Please help, its very urgent.

TIA
Mayank

Why not just open the file, retrieve the data and close the file.

If you use
application.screenupdating = false
'your code to retrieve the data
application.screenupdating = true

the user won't even know how it worked.

Mayank Prakash Gupta wrote:
>
> Hi All,
>
> Is there a way in which I can copy data from some named ranges in a excel
> workbook without actually opening it. I have to do it through VBA. The idea
> is to get the data from a file into the file which is running the VBA code.
>
> Please help, its very urgent.
>
> TIA
> Mayank

--

Dave Peterson