Vba excel screenupdating not working
On Time Now Time Value(""), "Acc Import" Dim Acc As New Access. Open Current Database "C:\Users\yilmadu001\Desktop\Database.accdb" Acc. Screen Updating = True End Sub Sub Acc Import() 'Application. Transfer Spreadsheet _ Transfer Type:=ac Import, _ Spread Sheet Type:=ac Spreadsheet Type Excel12Xml, _ Table Name:="Table1", _ Filename:=Application. Full Name, _ Has Field Names:=True, _ Range:="Data1$A1: BL40000" Acc.
About 2/3 of the way through the macro, the userform1 disappears, another worksheet pops up and then at the end of the procedure userform1 reappears with all text box's, combo box's complete and everything looks good. Word does not need to display itself in order to run.