Vb macros to schedule the excel sheet invisible mode

[psk]

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

 

[Frank Kabel]

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

 

[keepITcool]

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 >