Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Unanswered: open excel files one by one (with a 30min interval)

    Hi, I have no experience with Visual Basic but I need help from someone who has.

    Im interesting in a VB program that will open several excel file containing macros one by one.
    The files names and the directory in which the files are stored is always the same. The order in which they open doesnt matter.
    However, Id like each excel file to open 30 minutes after the previous one, to allow the macro to run.

  2. #2
    Join Date
    Mar 2004

    Re: open excel files one by one (with a 30min interval)

    Here are some steps to get you underway, you will have to adapt the code to fit your situation:

    1) Open a new VB standard project

    2) Add a timer control to your main form

    3) Make the timer interval 30 minutes

    4) Add code to the timer_timer event i.e.

    Dim exlApp As Excel.Application

    Set exlApp = New Excel.Application
    exlApp.Open "C:\File1.xls"

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    Apr 2004

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts