Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Automation

  Asked By: Adelisa    Date: Jan 27    Category: MS Office    Views: 449
  

I have a data source set up in Excel which imports data from AS/400,
everytime the Excel file is opened. I need to get this thing
scheduled. Has anyone worked with such a thing. Your input will be
really helpful. I was thinking may be i could use the windows
scheduler, but have no idea how to do it.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Birk Fischer     Answered On: Jan 27

Pls. use application.Ontime method to overide tis problem... More in HELP pls
refer that
AnSO

 
Answer #2    Answered By: Jordan Watson     Answered On: Jan 27

We have several Excel VBA applications that run over night
automatically. You need 3 things to make this happen. First, you have
to include a subroutine in "This Workbook," similar to the code shown below:

Private Sub Workbook_Open()

Application.Wait (Now + TimeValue("0:00:05"))

ClearOld

StageForecasts

AHAPSMailSub

Application.Wait (Now + TimeValue("0:0:30"))

ThisWorkbook.Save
Application.Quit


End Sub

This code calls 3 other subroutines plus saves and quits the
application. There are also some pauses to allow editing.

Second, the application has to be digitally signed, so it can run upon
opening without any input.

Third, schedule the application to run using the Scheduled Tasks utility
in Windows.

We've been running these for a few months and it works pretty well.

 
Didn't find what you were looking for? Find more on Automation Or get search suggestion and latest updates.




Tagged: