Auto open excel for every 30minutes

[bujji1305]

Hi friends,
I have excel file in my desktop and doing some report generation with that. i need to open that excel file for every 30minutes. How can i do? please help me?

 

[VishMishra]

Hi,

You can setup one scheduler in windows. You can schedule the below VBS file in windows

Copy and Paste the below code in to a Notepad and Save it with extn ".VBS"

Dim myExcel
Set myExcel = CreateObject("Excel.Application") 
myExcel.DisplayAlerts = False
myExcel.AskToUpdateLinks = False
myExcel.AlertBeforeOverwriting = False
myExcel.Workbooks.Open("C:\Users\vishwamitrad_m\Documents\Book1.xlsx")
myExcel.visible=true

 

[bujji1305]

Thank you vishmishra. How can i set the time interval so as to run it for every 30minutes. and where can i save it. I saved it on my desktop only.

 

[VishMishra]

Hi Refer the below link to see how to schedule a VBS file in Task Scheduler

http://www.iopus.com/guides/winscheduler.htm

In Triggers Tab of Task Scheduler you can set the time interval

 

[bujji1305]

yes its working vishmishra. thank you so much. but once my system was restarted is that vba script will work?

 

[VishMishra]

Yes it will work as long as your Scheduled Task is saved.