I am calling a sub that includes the input parameters, aws, awb, owb, ows and
mypattern (which is a string). We're having an inconsistent bug which
appears to occur when the owb is already opened and we reopen it. Has
anyone seen anything like this before and if so, what did you do to fix it?

Thanks,
Barb Reinhardt

--
HTH,
Bernie
MS Excel MVP


"Barb Reinhardt" <(E-Mail Removed)> wrote in message
news:3D21B770-B187-4525-AE07-(E-Mail Removed)...
>I am calling a sub that includes the input parameters, aws, awb, owb, ows and
> mypattern (which is a string). We're having an inconsistent bug which
> appears to occur when the owb is already opened and we reopen it. Has
> anyone seen anything like this before and if so, what did you do to fix it?
>
> Thanks,
> Barb Reinhardt

Barb,

Post your code. You probably just need to check to see if it is open first.

HTH,
Bernie
MS Excel MVP


"Barb Reinhardt" <(E-Mail Removed)> wrote in message
news:3D21B770-B187-4525-AE07-(E-Mail Removed)...
>I am calling a sub that includes the input parameters, aws, awb, owb, ows and
> mypattern (which is a string). We're having an inconsistent bug which
> appears to occur when the owb is already opened and we reopen it. Has
> anyone seen anything like this before and if so, what did you do to fix it?
>
> Thanks,
> Barb Reinhardt

Do you have to reopen it?

Could you just check to see if it's already open and just not open it?

Dim testWb as workbook
set testwb = nothing
on error resume next
set testwb = workbooks("somenamehere--not including path.xls")
on error goto 0

if testwkb is nothing then
'open it
else
'don't open it
end if



Barb Reinhardt wrote:
>
> I am calling a sub that includes the input parameters, aws, awb, owb, ows and
> mypattern (which is a string). We're having an inconsistent bug which
> appears to occur when the owb is already opened and we reopen it. Has
> anyone seen anything like this before and if so, what did you do to fix it?
>
> Thanks,
> Barb Reinhardt

--

Dave Peterson