How to add program to hide Excel session

[xiaoxshi]

I have an application to run Excel at the background and close Excel session after it exits. However, when application is running, Excel is popped up on the screen and easier for user to interfere the process so it is prone to user error.

I'd like to know an approach to hide Excel session when running at the batch mode.

Any suggestion is appreciated.

[Ron de Bruin]

You can use this maybe

Application.Visible = False


--
Regards Ron de Bruin
http://www.rondebruin.nl



"xiaoxshi" <[email protected]> wrote in message
news:[email protected]...
>
> I have an application to run Excel at the background and close Excel
> session after it exits. However, when application is running, Excel is
> popped up on the screen and easier for user to interfere the process so
> it is prone to user error.
>
> I'd like to know an approach to hide Excel session when running at the
> batch mode.
>
> Any suggestion is appreciated.
>
>
> --
> xiaoxshi
> ------------------------------------------------------------------------
> xiaoxshi's Profile: http://www.excelforum.com/member.php...o&userid=36665
> View this thread: http://www.excelforum.com/showthread...hreadid=564098
>

[Jim Thomlinson]

Be very careful hiding the instance of Excel. It tends to cause more problems
than it solves. The problem is that if something goes wrong then there is no
(easy way) to view the instance of Excel to see what is going wrong.
Additionally if a user opens a spreadsheet while the instance of Excel is
hidden it may open in the hidden instance... Just my two cents...
--
HTH...

Jim Thomlinson


"xiaoxshi" wrote:

>
> I have an application to run Excel at the background and close Excel
> session after it exits. However, when application is running, Excel is
> popped up on the screen and easier for user to interfere the process so
> it is prone to user error.
>
> I'd like to know an approach to hide Excel session when running at the
> batch mode.
>
> Any suggestion is appreciated.
>
>
> --
> xiaoxshi
> ------------------------------------------------------------------------
> xiaoxshi's Profile: http://www.excelforum.com/member.php...o&userid=36665
> View this thread: http://www.excelforum.com/showthread...hreadid=564098
>
>