Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows On/Windows Off
I have an Excel workbook with a sheet that hold data that I want to update
from an MS SQL database. Normally the sheet is hidden, and I want unhide it and place the recordset onto the sheet. I have the logic to copy the downloaded recordsheet, but what I want to do is open the workbook and retrieve a small dataset from the server without the user seeing the new sheet. My Excel help is rather limited on the company's PC, so if someone could assist with providing a little code chunk I would greatly appreciate it. In old (very old) versions of Lotus, a macro could run a WindowsOff Command to shut of the Windows updating while the macro was running. Is there something similar in VBA? TIA. Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows On/Windows Off
Not sure if this is what you are looking for, but you can switch off
Screen updating: Application.ScreenUpdating = False Hope that helps. Remy Blaettler www.collaboral.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows On/Windows Off
You must remember to set this back to TRUE once the macro has done its
work. Your error handler should also turn it back to TRUE. Pete |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows On/Windows Off
Thanks guys. It worked well.
"Pete" wrote: You must remember to set this back to TRUE once the macro has done its work. Your error handler should also turn it back to TRUE. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i want all windows in one excel frame (windows in taskbar) | Excel Discussion (Misc queries) | |||
cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
can windows vista edit shared document from windows xp | Excel Worksheet Functions | |||
Page breaks are different in Windows 2000 and Windows XP | Excel Discussion (Misc queries) | |||
Use Windows Script to run Windows Explorer Search? | Excel Programming |