Thanks Thanks:  0
Likes Likes:  0
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 26

Thread: Saving VBA Code And A Counter

  1. #11
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just thought of another one.

    Will the workbook with the command button be opened and closed? e.g. the user comes in, opens the workbook, presses the button, which copies and pastes the data, then closes the workbook.

    Assume that the user has opened and closed this workbook 250 times and each time pressed the button once. Do you still want the message box to appear, since the user has actually pressed this button 250 times?

    Out of interest why 250 times? I know that thread I posted before was from a fairly moronic and irrational kid, but you seem to have a bit more savvy about you. Did I see you mention your shipping company in another thread?

  2. #12
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    WILL THE RANGE NAMED "EXPORT1" BE OVERWRITTEN EACH TIME IT IS PASTED WILL IT BE PASTED TO A DIFFERENT PLACE ON THE TARGET WORKBOOK DOESIT MATTER IS IT IMPORTANT

  3. #13
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    PLEASE ANSWER I NEED TO KNOW THIS

  4. #14
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ????????????????????????

  5. #15
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Steve, that's a good question as well. Yes, Morrissey I will need to know this as well. I was just going to overwrite the range each time, but if it needs to be appended to the existing data to create a log, this could help.

  6. #16
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    APPENDED ON ONE SHEET I THOUGHT IT WAS TO GO ON SEPERATE SHEETS AND WHAT IS THE MESSAGE TO SAY JUST YOUV PRESSED THE BUTTON 250 TIMES OR SOMETHING ELSE

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

    Default

    Yes Well 250 That Is Because I Want To Save 250 Invoices Onto A CD Do I Can Save Hard Disk Space, Yes I Do Want THe NEw Data To Overwrite THe Old Data But It Will Be A Template So It Won't Matter

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

    Default

    PS yes It Will Be Closed

  9. #19
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Will it need to check if there is a CD in the drive Will it need to check if the CD is a writable CD Will it need to check if there is room on the CD if it is writable What kind of error message should be given if any of these happen

  10. #20
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How big will these invoices be will 250 fit on a CD

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
  •