Nigel:

To see if the workbook is open you can iterate through the Worbooks
collection examining the Name property versus the workbook name you are
seeking. If you do not find it in the Workbooks collection, then you can
open the workbook using the Workbooks.Open method. If you find the workbook
in the Workbooks collection, you can call the Activate method on the
workbook, and then use the Sheets and Cells collections to search, etc.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


"Nigel" wrote in message
...
Hi,
Here is my typical senario:
Quote book is open and i run a macro that gets the cell content from the
following cells( C2, C4, C5,G1)
These are all passed to a variable.
I need to open another workbook( if not already open), search a range of
B5:B1000 and find a amtching number that is equal to C2 in first book.

example
( job number = C2(2256))
need to find 2256 in other workbook in range B5:B1000

Once this has been found, i need to insert the other cell contents into the
cells on the right of this first cell.

Example
B D E F ( columns)
(2256 £12,000 £3500 £4000 ( Cell contents )
C2 C4 C5 G1 ( Range in first workbook )

I am really struggling with a routine to open the book if it is not open or
switch to it if it is open ( yo prevent open read only ) search the range
for
a matching value, and inserting the cell contents. This is going to ave me
hours if not days & weeks of work.

any help greatly appreciated.

Regards,

Nigel