Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Automated start process in dashboard (Read 2819 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Automated start process in dashboard
13.10.07 at 15:00:15
 
Automated start process in dashboard
 
Question:
We are looking for automated process to start the queries in our
dashboard. For example: Every Day at 8:00 execute the macro.
 
Do you have an idea how to do this?
 
Answer:
This is rather easy to accomplish when you have the workbook open. You can use the OnTime method of the Excel.Application object. Syntax:
expression.OnTime(EarliestTime, Procedure, LatestTime, Schedule)
 
Example:
Run MyMacro in one minute from now:
Application.OnTime Now + TimeValue("00:01:00"), "MyMacro"
 
If the workbook is not already open you can code a call to your macro in the ThisWorkbook.Workbook_Open event. Then schedule the opening of the workbook on the computer using the scheduler. See:
 
SCHEDULE and FTP REPORTS
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1140109901
Back to top
 
« Last Edit: 13.10.07 at 15:08:57 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1