+ Reply to Thread
Results 1 to 11 of 11

using a timer to automate a macro

  1. 11-30-2009, 10:26 AM #1
    vwm1
    vwm1 is offline
    Registered User
    Join Date
    11-30-2009
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    8

    using a timer to automate a macro

    Hi,

    I cant figure out how to get the data to be pasted in the cell below on each new event of the timer. below is teh code i'm using 

    Please Login or Register  to view this content.
    The code updates as it should but overwrites the same cells each time.

    Any help much appreciated
    Last edited by vwm1; 11-30-2009 at 10:36 AM.
    Reply With QuoteRegister To Reply
  2. 11-30-2009, 10:30 AM #2
    Jack in the UK
    Jack in the UK is offline
    Valued Forum Contributor
    Join Date
    07-21-2008
    Location
    London, UK
    Posts
    326

    Re: using a timer to automate a macro

    I think your need to sort your post out see rule 3 i think it is

    I can not reply until you have

    jiuk
    Reply With QuoteRegister To Reply
  3. 11-30-2009, 10:36 AM #3
    vwm1
    vwm1 is offline
    Registered User
    Join Date
    11-30-2009
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: using a timer to automate a macro

    opps sorry corrected now
    Reply With QuoteRegister To Reply
  4. 11-30-2009, 10:40 AM #4
    Jack in the UK
    Jack in the UK is offline
    Valued Forum Contributor
    Join Date
    07-21-2008
    Location
    London, UK
    Posts
    326

    Re: using a timer to automate a macro

    What is

    RefreshData
    Reply With QuoteRegister To Reply
  5. 11-30-2009, 10:42 AM #5
    Jack in the UK
    Jack in the UK is offline
    Valued Forum Contributor
    Join Date
    07-21-2008
    Location
    London, UK
    Posts
    326

    Re: using a timer to automate a macro

    this is the past code you have 
    Please Login or Register  to view this content.
    As you saying each time you run the code you want the paste to be G18 then G19 G20 etc ?
    Reply With QuoteRegister To Reply
  6. 11-30-2009, 10:43 AM #6
    vwm1
    vwm1 is offline
    Registered User
    Join Date
    11-30-2009
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: using a timer to automate a macro

    sorry it is a subroutine. please see attached for full code.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 11-30-2009, 10:44 AM #7
    vwm1
    vwm1 is offline
    Registered User
    Join Date
    11-30-2009
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: using a timer to automate a macro

    yup exactly that each time it goes over the top, i tried looping it but think i got it wrong.... as just repeated same line over again rather than in time increments
    Reply With QuoteRegister To Reply
  8. 11-30-2009, 10:44 AM #8
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: using a timer to automate a macro

    The rows variable will be zero'd every time the routine runs.

    Use code to get next empty row.

    Please Login or Register  to view this content.
    Last edited by Andy Pope; 11-30-2009 at 10:53 AM.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  9. 11-30-2009, 10:51 AM #9
    Jack in the UK
    Jack in the UK is offline
    Valued Forum Contributor
    Join Date
    07-21-2008
    Location
    London, UK
    Posts
    326

    Re: using a timer to automate a macro

    No idea how right this is going to be but rlls teh G18 for input and next time will be g19 etc 
    Please Login or Register  to view this content.
    The magic is this bit 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 11-30-2009, 10:58 AM #10
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: using a timer to automate a macro 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 11-30-2009, 11:09 AM #11
    vwm1
    vwm1 is offline
    Registered User
    Join Date
    11-30-2009
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: using a timer to automate a macro

    hey guys,

    looking good thanks for all your help is much appreciated
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1