Hi Friends,
I need to schedule the excelsheet conatining macros .For that what
have to include in the VBcode to run in the invisble mode .also for th
code ..which reference i have to include ..Can u help me ?

When i schedule it ,it is opening the excel sheet.

Thank

--
ps
-----------------------------------------------------------------------
psk's Profile: http://www.excelforum.com/member.php...fo&userid=1573
View this thread: http://www.excelforum.com/showthread.php?threadid=27262

Hi
what do you mean with 'invisible mode'
maybe
application.screenupdating=false

--
Regards
Frank Kabel
Frankfurt, Germany

"psk" schrieb im Newsbeitrag
...

Hi Friends,
I need to schedule the excelsheet conatining macros .For that what i
have to include in the VBcode to run in the invisble mode .also for
the
code ..which reference i have to include ..Can u help me ?

When i schedule it ,it is opening the excel sheet.

Thanks


--
psk
---------------------------------------------------------------------
---
psk's Profile:
http://www.excelforum.com/member.php...o&userid=15738
View this thread:
http://www.excelforum.com/showthread...hreadid=272624

or to hide excel completely:

Application.Visible = False

however.. be sure to make your code bulletproof..
and make sure that if an error is encountered
you either handle it or set application.visible to True.

it's not easy to get it visible again from "the outside"..


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Frank Kabel" wrote:

Hi
what do you mean with 'invisible mode'
maybe
application.screenupdating=false

--
Regards
Frank Kabel
Frankfurt, Germany

"psk" schrieb im Newsbeitrag
...

Hi Friends,
I need to schedule the excelsheet conatining macros .For that what i
have to include in the VBcode to run in the invisble mode .also for
the code ..which reference i have to include ..Can u help me ?

When i schedule it ,it is opening the excel sheet.

Thanks


--
psk
---------------------------------------------------------------------
--- psk's Profile:
http://www.excelforum.com/member.php...o&userid=15738 View
this thread:
http://www.excelforum.com/showthread...hreadid=272624