Application screenupdating doesn t work updating host file
If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
o Story is a range of values for updating the formfields in a document Please view code, What happens is Update() is called at the beginning, it asks to input a title, the title is updated for the formfields in the current document ie. What happens next is that Call Sheet Print Out is called which takes the current document file name, searches an excel spreadsheet for the document file name value, then offsets and creates a list called forms of the offsetted value Ex FNList. Once the forms are opened the formfields are then updated and the forms are printed off. Sub Update() Dim Title As String Dim frm Title As User Form1 Dim o Story As Range Application. Then place the names of travel expenses in say D5 and training expenses in F5.
These forms are then opened in word like so Set b Doc = Documents. What happens though is that the screenupdating works for the excel part, it then when it gets to word for opening the forms, shows opening the forms and a message appears on the status bar, stating word is updating fields in the current document. Screen Updating = False Set frm Title = New User Form1 With frm Title .
I have tried moving the screenupdating, displayalerts, displaystatusbar to different parts of the doc but i still get this. Are you using office 2007 and when you run the code you are running in debug mode? Everytime it offsets it opens the cell value say c:\forms\travel expenses ; if travel expenses is in the cell.
(that doesn't let you turn off screen updating..least I haven't found a way to do so for debuggin in 2007) Hey Malik thanks for your reply. Text End With Unload frm Title Set frm Title = Nothing Call Update Story Ranges(Active Document) Call Sheet Print Out Application. It will then print off these and update any of the fields.
I use Application.screenupdating = false several places in my project. workbooks("book1")My main book, where the code resides, disappears, and book1 comes to the top.
I control multiple workbooks with my code,and I can see the workbooks become activated as the code works through them. This makes it so I can't see my main book, and I need to see it during the save. Is there a way to completely turn off all screen changes, or is this yet another part of VBA that doesn't work 100% like it is supposed to?