How do I open a file from a named cell?

Hi, this will be an easy one for you!

In my macro, I want to open a file based on a cell's contents.

So, if A1 contained "book1.xls", how do I open the file by referencing the cell in the macro?

Thanks in advance.

It's OK, I've worked it out now!

workbooks.Open range("A1").value

Workbooks.Open Range("A1").Text

HTH
--
AP

"Cumberland" <Cumberland.28939z_1148371203.2278@excelforum-nospam.com> a
écrit dans le message de news:
Cumberland.28939z_1148371203.2278@excelforum-nospam.com...
>
> Hi, this will be an easy one for you!
>
> In my macro, I want to open a file based on a cell's contents.
>
> So, if A1 contained "book1.xls", how do I open the file by referencing
> the cell in the macro?
>
> Thanks in advance.
>
>
> --
> Cumberland
> ------------------------------------------------------------------------
> Cumberland's Profile:
> http://www.excelforum.com/member.php...o&userid=33445
> View this thread: http://www.excelforum.com/showthread...hreadid=544568
>