Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Huntingdon Valley, PA USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Beginner Question (Excel 2002 SP2)

    Is there a command in Excel similar to the "Echo" command in Access. I have a form which enters data into several worksheets and I'd like to stop the switching to the various worksheets. I'd like to data to be added in the background. I hope this makes sense. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Beginner Question (Excel 2002 SP2)

    Put Application.ScreenUpdating = False before, and Application.ScreenUpdating = True after the code.

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Beginner Question (Excel 2002 SP2)

    I'd just add to Hans' reply the value of placing such code inside an error trap, to ensure that ScreenUpdating is still restored, even if an error occurs within your code:

    On Error GoTo ErrorHandler ' Enable error-handling routine.
    Application.ScreenUpdating = False

    ' Your code here

    ErrorHandler: ' Error-handling routine.
    Application.ScreenUpdating = True
    End Sub

    As I recollect, a recommendation by HansV, I believe. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Alan

  4. #4
    New Lounger
    Join Date
    Apr 2002
    Location
    Huntingdon Valley, PA USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Beginner Question (Excel 2002 SP2)

    Thanks for taking the time to answer my question. I actually have the Excel Language Reference book and looked in the Application Object section and didn't see that. Of course, I really don't know what I'm doing.

    cmckeever

  5. #5
    New Lounger
    Join Date
    Apr 2002
    Location
    Huntingdon Valley, PA USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Beginner Question (Excel 2002 SP2)

    Thanks for taking the time to answer my question. I actually have the Excel Language Reference book and looked in the Application Object section and didn't see that. Of course, I really don't know what I'm doing.

    By the way, nice picture.

    cmckeever

  6. #6
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Beginner Question (Excel 2002 SP2)

    CMC,
    Maybe you don't "Know what you're doing" just now, but I bet that's where most of us were at one time: facing an Excel screen, pushing F1 or looking in a book, thinking, "There must be another, better/easier/faster way to do this." The Application.Update is not easy to find, but I learned about it here in the Lounge.

    Just keep up the "There must be..." attitude, and put a "Lounge" link on your Toolbar.

    Errol

  7. #7
    New Lounger
    Join Date
    Apr 2002
    Location
    Huntingdon Valley, PA USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Beginner Question (Excel 2002 SP2)

    Hi Errolv,

    I will keep the link to the Lounge. I just finished the Excel project I was working on. It is working OK, but I did have some trouble with the "Application. Update = True" statement. The form would freeze up on me sometimes so I disabled it for the time being. When I get some time I'll try to investigate it.

    I have another Excel project that I want to start and I know that I'll need help. It's a financial statement type program. I
    have custom reports that I have to do every month and I want to automate it with M$ Word. Can you do queries in Excel?

    cmckeever@comcast.net

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Beginner Question (Excel 2002 SP2)

    >Can you do queries in Excel?

    MSQuery is part of the full install of Excel options. You can build queries with this - though they tend not to be quite as fancy as they can be in Access.

    HTH
    Gre

  9. #9
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Beginner Question (Excel 2002 SP2)

    I haven't used these myself, but my copy of Excel 2000 has a few. Open Help, and enter "Database Functions". Depending on how elegant you want to query, these might do the job.

    Errol

  10. #10
    New Lounger
    Join Date
    Apr 2002
    Location
    Huntingdon Valley, PA USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Beginner Question (Excel 2002 SP2)

    I'm going to start this project today. It's too cold to do any work outside. I'll check out your suggestion on Database Functions and the MSQuery suggested by another guy.

    By the way, nothing I do is elegant!

    cmckeever

  11. #11
    New Lounger
    Join Date
    Apr 2002
    Location
    Huntingdon Valley, PA USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Beginner Question (Excel 2002 SP2)

    Thanks for the suggestion. I'm going to start working on the project today. I'll check M$Query out. If I can't figure it out I now know whom to bother, I mean, ask for help. <g>

    cmckeever

Posting Permissions

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