+ Reply to Thread
Results 1 to 12 of 12

Excell magic to open an excell sheet at a predetermined time

  1. #1
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Excell magic to open an excell sheet at a predetermined time

    Hai dear friends

    I am looking for some VB
    1.. to make my excell sheet to open automatically at a particular time of the particular day
    Say for examply on monday 10 pm
    2.. to open a particular excell sheet on a particular fixed/predetermined day automatically when i booted the computer

    Is it is possible to do the above tasks

    Thank you

  2. #2
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    my application.ontime macro is not working

    Hai i have the following code to run the macro ""my macro"" automatically after some time(her but it does not work
    can any body please help me to solve my problem

    Private Sub Workbook_Open()
    Application.OnTime Now + TimeValue("00:00:25"), "MyMacro"

    End Sub

    Sub mymacro()
    Range("a1:a25") = 5000
    End Sub

  3. #3
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    163

    Re: Excell magic to open an excell sheet at a predetermined time

    Change Sub mymacro to Sub MyMacro

  4. #4
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Re: Excell magic to open an excell sheet at a predetermined time

    hai sbarro

    it is still not working ya

  5. #5
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Ontario Canada
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: Excell magic to open an excell sheet at a predetermined time

    is mymacro in the same module as workbook_open?
    also, what error exactly are you getting?

  6. #6
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Re: Excell magic to open an excell sheet at a predetermined time

    hai jason thanks for your reply

    yes both macros are written in sheet1 ,i tried in putting them in module also but it is not working

    actully there is no error coming, you see this macro is meant for filling up a1 to a25 by 5000 after 25 seconds but it does nothing after 25 seconds

  7. #7
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    907

    Re: Excell magic to open an excell sheet at a predetermined time

    Quote Originally Posted by catchnanan View Post
    Is it possible to do the above tasks
    You will need to use Scheduled Tasks in Control Pannel to launch your Excel workbooks.

  8. #8
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    163

    Re: Excell magic to open an excell sheet at a predetermined time

    Put Private Sub Workbook_Open() procedure into Thisworkbook module, and MyMacro procedure into Module1.

  9. #9
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Re: Excell magic to open an excell sheet at a predetermined time

    Hai sbarro now it is absolutely working but only when i remove the word private
    and i have to run the workbook macro ...but i wnt it to be automatic without myself running the workbook macro

  10. #10
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    163

    Re: Excell magic to open an excell sheet at a predetermined time

    Ok, try my file and see, if you have the same problem
    Attached Files Attached Files

  11. #11
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Ontario Canada
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: Excell magic to open an excell sheet at a predetermined time

    rollis13 is right.
    If you want this to open automatically and run the macro every x seconds, you need to schedule it in Windows Scheduler.

  12. #12
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Re: Excell magic to open an excell sheet at a predetermined time

    Hai jason thanks again

    hai sbarrow where actually the private application.ontime timevalue function in your excell sheet
    sorry for the delay i was having the connectivity problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. create a slides show with excell spreadsheets using excell
    By wantabepas in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-16-2006, 02:50 PM
  2. Replies: 1
    Last Post: 05-08-2006, 01:31 PM
  3. Replies: 1
    Last Post: 02-22-2006, 06:30 PM
  4. Replies: 0
    Last Post: 08-24-2005, 07:41 AM
  5. [SOLVED] Can I view an excell document without excell (not installed wit.
    By Kevin in forum Excel General
    Replies: 1
    Last Post: 02-16-2005, 04:27 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1