Re: searching is leaving line's on the screen by Lars-Eric
Lars-Eric
Mon Jul 07 10:39:42 CDT 2003
Carl,
Looks like the same probles as when you have a document with several pages
and copying between formfields. If you have formfields on page 1 that needs
to be copied to formfields on several following pages the screen turns havoc
(Screenupdating=False). This is confirmed by Microsoft and no solution
available. The way solved the problem was using WordBasic syntax instead and
the screen was totally stable, plus, it was a tremendous speed improvment.
Perhaps you could try to use the WordBasic syntax instead of VBA syntax and
see what happens. We have a number of Tax and Customs forms (Customs forms
can be up to 17 pages) with a lot of calculations between formfields and
there is no way we can use 'Activedocument.FormField()' syntax. It's just to
slow and the screen is jumping up and down and get scrambled. With WordBasic
syntax it's even faster with VBA than using formulas in the FormFields plus
the screen is totally stable.
Regards,
Lars-Eric
"Carl" <carl_programmer@hotmail.com> skrev i meddelandet
news:093001c34481$e7ea2e60$a301280a@phx.gbl...
> My Application is to big! and i meen Big
> more than 15 themplates using a library of macro!
> use by 300 people every day!
> Every thing works fine, but it's those lines that i don't
> like.
> they appear when, for example i am sorting information in
> a document, the document is going up and down like crazy
> while searching and this is where the line apear, only
> while searching through the document. And it's stop after.
>
> so i use Application.ScreenUpdating = False
> before my search begin's, and Application.ScreenUpdating =
> True after.
> this accelerate my application but doesn't help for the
> line.
>
>
> >-----Original Message-----
> >Hi Carl,
> >
> >I am not sure what type of lines you are talking about.
> >
> >Maybe if you show us the code of your macro we can see
> what it is doing and
> >what can be done about it.
> >
> >Please respond to the newsgroups for the benefit of
> others who may be
> >interested.
> >
> >Hope this helps
> >Doug Robbins - Word MVP
> >"carl" <carl_programmer@hotmail.com> wrote in message
> >news:0b6c01c340ae$d47ffa70$a501280a@phx.gbl...
> >> if any one can help, it would be grate.
> >> My macro is searching through an open word document,
> >> while is searching is leaving line's on the screen!
> >> even whith ScreenUpdate to False nothing is change.
> >> I don't wont those line to apear while the search is
> going
> >> on.
> >> can any one tell me if this can be deal whith?
> >> An how?
> >> Thanks
> >
> >
> >.
> >