Excel vba application screenupdating false
We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.
Like I said in the previous post, please place "Option Explicit" at the top of the module and click Debug-Hi Malik When you say the screen updating works fine for you, do you mean you don't get a message in the status bar saying Word is updating the fields in this document, the document will not look fully opened but the title of the document will appear at the top.
It just sits in memory not doing anything except using up your resources.
Plus you never "Close" the document and "Exit" the application.
You see you have a document opened named May2008What happens is you call the macro Update It will then conduct a find on the following path C:\A search is done on column C for May2008, the document that is open at that given time.
Find(Word FN, Look In:=xl Values) If Not c Is Nothing Then First Address = c. Set o Rng = Nothing Set o Sheet = Nothing Set o WB = Nothing Set o XL = Nothing 'quit Exit Sub Err_Handler: 'Msg Box Workbook To Work On & " caused a problem. Hey Malik No the status bar is working but i will try knock it off.