+ Reply to Thread
Results 1 to 3 of 3

Alternative faster way to do the same thing

  1. #1
    Registered User
    Join Date
    12-30-2011
    Location
    Jeannette, PA
    MS-Off Ver
    Excel 2010
    Posts
    19

    Alternative faster way to do the same thing

    While the following code works, there must be a way to speed up the process.
    Also, this code has a progress bar (which does not show correctly)and percentage display which doesn't show till the process is complete. I just can't seem to figure out why.

    Please Login or Register  to view this content.
    Any help would be nice
    Thanks

  2. #2
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: Alternative faster way to do the same thing

    Can you try uploading an example workbook with dummydata and a descirption of what your trying to accomplish?
    Please take time to read the forum rules

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Alternative faster way to do the same thing

    1) The inclusion of "progress bar" functions inherently slows macros down. You sure you need that?
    2) Explain in words what the macro does (don't "think" in code, either, just explain in layman's terms)

    Perhaps I can suggest an alternate method to accomplish the same thing more quickly? If you post a sample workbook showing what you're doing and what the "desired results" would be, even faster for us to get it.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  4. #4
    Registered User
    Join Date
    12-30-2011
    Location
    Jeannette, PA
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Alternative faster way to do the same thing

    I should be more clear. The following spreadsheet, upon activation (macro enabled) displays a popup asking what workorder(spreadsheet) will be used. The file is then selected by the user. (by turning visable off on some of the labels and on on others I change it to show the progress indicaters)The file that is selected looks identical to sheet1 but has information filled in. It is known that there are 75 columns in the sheet but it is not known how many rows have information. By using the DO WHILE NotDone = "Yes" and looking at the values in column 6 I can count how many rows have information until row 6 has a blank "" The information does not start until row 5. (because of the column headers)

    Once I know how many rows have information, I can use For and Next loops to transfer the data from the user selected workorder cells (some of which may be hidden) to this workorder. (this seems to take forever(the reason i added the progress bar) if there are over 1000 rows) and progress blocks appear but with no frame and the perc textbox does no show until the the process completes

    The reason for transfering all the information is so I can change how the information is displayed and edited and create some custom reports in some sheet I haven't added yet. I am not allowed to modify the original workorder's appeariance, but if i import into my custom sheet I can do anything I want with it and just write the data back once any changes are complete.

    I hope this helps

    Attachment 134372

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1