Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
VBA with MS Excel
Name: bijus_s Date: August 15, 2008 at 08:01:39 Pacific OS: XP CPU/Ram: P4 Product: Intel
Comment:
I need to run a program to sort an excel sheet but dont want to see the processing/flash on screen going on. Hence want to keep a form/module/screen to show - "Please wait while the processing is going on" and the sorting program to run in background. How can i do that?
Name: Razor2.3 Date: August 17, 2008 at 19:42:17 Pacific
Reply:
You can set some text in the status bar, then disable screen updating. Like so:
Sub sorting() On Error GoTo EoS 'This is important DO NOT skip it. Application.StatusBar = "Please wait while the processing is going on" Application.ScreenUpdating = False
'Sorting code here
'This is important DO NOT skip it. EoS: Application.ScreenUpdating = True Application.StatusBar = False If Err.Number Then _ MsgBox Err.Description, vbCritical + vbOKOnly, Err.Number End Sub
Summary: i am having problem of conversion of ms-excel sheet into ms-access database. i am using java language as frontend and ms-access as backend. ...
Summary: I need to create a batch file that will clear the "browse in same window check box" from the Tools -> Folder Options -> File Types tab -> .xls -> Advanced. My problem is that I have an Excel file on a...
0 
