Windows On/Windows Off

[Guest]

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

 

[Remy]

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

 

[Pete]

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

 

[Guest]

Thanks guys. It worked well.