Excel application screenupdating not working

It happens when there is transition among excel files.

The same macro worked properly in win 7 with office 2010.

Range Dim First Address As String Dim Excel Was Not Running As Boolean Dim Workbook To Work On As String Dim Word FN As String Dim Excel FN As String Dim a Col As Integer Dim Ex Fn List As String Application. You might need to create a Word doc called May2008, then go into C:\and put say May2008 in C5, you will also have to create word docs called travel expenses.doc, training in c:\forms.

The screen flickers (presumably when opening each document)? TIA Sub Insert Text() Dim Shp As Shape, Doc As Document, str Text To Insert As String, str Text To Find As String Dim i As Long, doc To Open As File Dialog, s Hght As Single Dim rng To Search As Word. Data Object On Error Go To Err_Exit 'str Text = Input Box("New Text", "Header Textbox Update", "New Text") ' Switch off the updates of screen Application. File Dialog(mso File Dialog File Picker) doc To Open.

Since my computer was upgraded to win 10 with office 2016, Application.screenupdating=false command in VB (excel) doesn't work properly.

The screen flickers and the excel macro runs slowly.

Visible = True here; but your code will 'run faster if you don't make it visible 'Open the workbook Set o WB = o XL. Open(File Name:=Workbook To Work On) Set o Sheet = o WB. Everytime it offsets it opens the cell value say c:\forms\travel expenses ; if travel expenses is in the cell.

Screen Updating = False Workbook To Work On = "C:\forms\index.xls" 'If Excel is running, get a handle on it; otherwise start a new instance of Excel On Error Resume Next Set o XL = Get Object(, "Excel. Number 0 Then Excel Was Not Running = True Set o XL = New Excel. Screen Updating = False End If On Error Go To Err_Handler 'If you want Excel to be visible, you could add the 'line: o XL. When the macro is called for May2008, May2008 is found in say C5 and offsetting of cells will take place.

Leave a Reply