Hi Barb,

Where should I see myname once I have put that line in?
Here are Immediate Window Contents when Set myWB = Workbooks.Open(myName) is
in yellow after the runtime error.
[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs]
[PickPlatform] <
[PickPlatform]
[VerifyOpen] <
[VerifyOpen] 1
[RegisterFunctionIDs] <
[RegisterFunctionIDs]
[auto_open]

I'm going to have to google immediate window 'cos i don't know what it is.

Would it help to know that myName ="" when you hover over it in the code and
that myWB = nothing? Path has the expected pathname.

I'm not sure I understand what you mean by "concatenate the path name the
you selected to the myName value" (never mind not sure, call a spade a spade,
I just don't understand :-))
--
Deirdre (finding this exciting and frustrating in equal measure!)


"Barb Reinhardt" wrote:

Put

Debug.print myName before the error and see what it gives you. It should
show the full path. If it doesn't, (and I may have forgotten that), you'll
need to concatenate the path name the you selected to the myName value.
--
HTH,
Barb Reinhardt