Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Saving A Selection Of Excel And Counting How Many Times It I

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Everyone I've Got Yet Another Problem Which I Need Your Help With I Need The Macro Code For

    When I Click A Button I Would Like Excel To

    1. Copy And Paste A Selection I have Made (It's Called 'export1') On To Another Template I Have Made (C:IFSInvoice Template.Xlt)

    2. Save That

    3. When That Button Is Pressed Record How Many Times It Is Done (I Want 250 Times) And Have A Message Coming Up.


  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    can`t you just fill a cell with value 0 and include a function to add 1 to that value everytime the export occurs.

    Secondly include an evaluation of the cell value.When>250 let a msgbox appear.

    ?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry I need the whole code how to do this I have no knowledge of VB

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    mm, welll. finding out is part of the sport In my oppinion.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yes well can someone who is willing to help me and doesn't believe in sport of learning VBA please help

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I will suggest only the 3rd question
    1. put this before doing Process
    StartTime = Timer
    2. Put This After doing Process
    EndTime = Timer
    3. put This in Module

    Dim StartTime, EndTime As Date
    MsgBox "Finish ! Using Time " & Format(EndTime - StartTime, "0") & " Second", vbExclamation + vbOKOnly, "Remark"

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Run something like this in the same sub as your export macro.

    Worksheets("sheet1").Range("a10").Value = a10 + 1

    And then something like this: in another sub:

    if a10.value >250 then
    MsgBox "big boy, you did it 250 times!", vbExclamation, "big boy"
    end if


    [ This Message was edited by: Dinictus on 2002-03-21 03:39 ]

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If only you could get a wav. file to say that instead of a message box eh? You'd be the envy of the office

    [ This Message was edited by: Audiojoe on 2002-03-21 03:17 ]

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Tell `em audiojoe,

    Tell `em how you do that!

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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