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