Vb macros to schedule the excel sheet invisible mode

  • Thread starter Thread starter psk
  • Start date Start date
P

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
 
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 >
 
Back
Top