Keeping Excel hidden until export is complete

[bd528]

Hi all,

I am exporting various types of data from Access to Excel using

Dim excelApp As Object
<snip>
Set excelApp = CreateObject("Excel.Application")

I then do some formatting, etc in Excel via Access VBA

This all works perfectly.

What I would like to do though, purely for aesthetics, is keep the Excel window hidden until the export and formatting is complete.

If this is possible, can someone provide the necessary code.

Thanks in advance

 

[Minty]

I think something like

 With excelApp
            .Visible = False
            do your formatting shizzle here
            .Visible = True

might work.

 

[bd528]

I think something like

 With excelApp
            .Visible = False
            do your formatting shizzle here
            .Visible = True

might work.

Perfect. Thanks again for your help.