Ask Experts Questions for FREE Help !
Ask
    excelmacro0123's Avatar
    excelmacro0123 Posts: 5, Reputation: 1
    New Member
    		  
    #1

    Dec 23, 2008, 07:42 AM
    Excel macro
    I need to run a macro that opens excel so I can kick off "application.ontime" basically my macro should run without me having to start excel, just have the computer and outlook running.

    Is that possible?
    StaticFX's Avatar
    StaticFX Posts: 943, Reputation: 74
    Senior Member
    		  
    #2

    Dec 23, 2008, 07:57 AM

    Need more info:

    When should this run? On boot, at a certain time?
    How often? Every boot etc...

    What do you mean kick off "application.ontime" is that a macro in excel?

    More details please :)
    excelmacro0123's Avatar
    excelmacro0123 Posts: 5, Reputation: 1
    New Member
    		  
    #3

    Dec 23, 2008, 08:00 AM

    It should run once a day, but it should run regardless if I have Excel open or not.

    Application.ontime is what I was planning to use to run the macro at a certain time.
    Please let me know if you need more info.

    Thank you,
    StaticFX's Avatar
    StaticFX Posts: 943, Reputation: 74
    Senior Member
    		  
    #4

    Dec 23, 2008, 08:24 AM

    OnTime: Automatically Run Macros at a Set Time or Date. Application.OnTime
    excelmacro0123's Avatar
    excelmacro0123 Posts: 5, Reputation: 1
    New Member
    		  
    #5

    Dec 29, 2008, 09:13 AM
    Thank you,
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Auto-Macro in Excel [ 4 Answers ]

Hi, I have a lot of macros built-in Excel, but when I want to update the certain data , I have to run them individually each time. Do you know anyway I can auto-run these macros? Thanks for any help.

Recording a macro in Excel [ 2 Answers ]

Need a macro that will select the cell one place to the left, edit the content, hit enter, and then move to cell below where started and repeat to end of column (last cell with a value). Example: 123-456789 is format of cell to be edited - need to remove the hyphen. Someone had created it...

How to Automate a macro in excel [ 4 Answers ]

A program logs files at random in txt. abc_log.txt (example) When new info. Is added to the txt file,manualy activate macro and it does what it suppose to do, all OK there. Is there a way a macro code or excel, or perhaps a BAT program can be made to simply "detect" when new data is added...

View more questions Search