Search:

Type: Posts; User: Luthius; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Performance: What is the best "method" to pull data from Several WorkBooks using VBA

    When I wrote best I mean for peformance sake. Just like I wrote before



    CStr(i) was used on both

    clc.Add i, CStr(i)
    dic.Add CStr(i), i
  2. Re: Performance: What is the best "method" to pull data from Several WorkBooks using VBA

    Thanks for the website post.
    But testing with a straightforward code the result is different.
    See below

    Option Explicit

    Sub Collection_VS_Dictionary()
    Const iterations = 500000
    Dim...
  3. Re: Performance: What is the best "method" to pull data from Several WorkBooks using VBA

    My purpose is understand the limitations and also the pros and cons.
    Just Like Collection is faster than Dictionary, what would be the best options when bearing with a big amount of data (different...
  4. Re: Performance: What is the best "method" to pull data from Several WorkBooks using VBA

    My purpose is understand the limitations and also the pros and cons.
    For instance, we know that Collection is faster than Dictionary. But Dictionary has more features that Collection. So we can...
  5. Re: Performance: What is the best "method" to pull data from Several WorkBooks using VBA

    Interesting performance.

    Well, what about several workbooks (100, 1000, +).
    Using the method of Open/Close workbooks causes a crash. I tested it, by looping through 20 Workbooks with the same...
  6. Re: Performance: What is the best "method" to pull data from Several WorkBooks using VBA

    Excel Version: 14 64-bit
    Windows: 7 Enterprise
    1st Code:18s
    2nd Code: 16s

    Using Matlab: 0.8s
  7. Performance: What is the best "method" to pull data from Several WorkBooks using VBA

    Guys
    I know that there is more than one way to skin a cat, but what is the best way to pull down data from more than 01 workbook taking into consideration the performance of the code?



    Pull...
  8. Replies
    2
    Views
    397

    Re: Excel 2019 Performance vs Excel 2010

    I guess it can help you.
    https://docs.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-performance-and-limit-improvements
  9. Re: VBA - How to invert/sort line breaks within a cell

    Amazing solution. Thank you very much

    Mr Rick and also for the the second solution Mr CalcSux78.
  10. VBA - How to invert/sort line breaks within a cell

    Guys, how can we change the line breaks order within a cell?
    For instance, in my cell I have the values:

    A1 Cell

    <tbody>
    1st Comment
    2nd Comment
    3rd Comment
  11. Create a new table with the results of a query that uses multiples criterias from 2 different tables

    Guys

    I have one table that contains a memo field (tblWithMemoField)
    The second table has some keywords (tblWithKeyWords)

    What I want to do is a query that can generate a table using the field...
  12. Re: How to distribute known numbers into columns using VBA

    Your code is amazing, but it takes a while to run when there are too many groups to be generated.

    I would like to share with you a code and at the same time request assistance on how to make some...
  13. Re: How to distribute known numbers into columns using VBA

    Thank you very much. I made the changes you suggested and its working fine.
    I will study your precious code, maybe in the future, if you allow me, I will be able to make some changes.

    Thanks you...
  14. Re: How to distribute known numbers into columns using VBA

    Amazing, its working. Thank you very much for your time and your code.

    One last thing, is possible I increment one element in my group, I mean, I tried changing from 15 to 16 this part of the code...
  15. Re: How to distribute known numbers into columns using VBA

    Unfortunately not.
    When I'm saying "10 unique groups of 15 numbers to be generated", means each group will have 15 elements, and there is no repetition of all elements between them.
    Below a random...
  16. Re: How to distribute known numbers into columns using VBA

    Fistly I would like to correct a mistake I made, instead 05 numbers choosen, the correct is 06 numbers.


    Thank you for taking your time to assist me.
    Unfortunately is not like that.


    I'm...
  17. Re: How to distribute known numbers into columns using VBA

    Anyone?
  18. Re: How to prevent rows, columns, or cells from being deleted

    If you create an array formula and hide it (by column or by row) no one can delete nor column or row.
  19. Distribute known numbers into columns using VBA

    I have 2 set of numbers that I would like to mix them.
    My first set contains 15 numbers that I would like to combine with a set of 10 numbers and distribute them into colunms.
    From the set of 15...
  20. Hints for Best Practice to work with SQL Server data mixed with MS access data tables

    Guys
    We have a CMMS that its database is SQL Server.
    My intention is to retrieve some information that is already there and use it in my MS Access database for Issues management.
    I already setup a...
  21. Re: How to send email based on criterias of the spreadsheet

    Below the code using Dictionary where I can store the CC and To recipients.


    Sub dicionario()

    Dim ws As Worksheet
    Dim rg As Range
    Dim strTo As String
    Dim strCC As...
  22. Re: How to send email based on criterias of the spreadsheet

    And how about the Column C where is define if the email recipient will be To or CC? These will be parameters for the email routine right???
    Also I need to define on my code if the email will be sent...
  23. How to send email based on criterias of the spreadsheet

    I would like to send an email for each person in a table based on the confirmation column.
    Meaning if is True, that person will receive the email. Otherwise not.

    I would like also to choose to...
  24. Re: How to read values from Txt File as unique values

    Thanks for the explanation. Clever solution.
    Lets consider closed this thread. Thanks again
  25. Re: How to read values from Txt File as unique values

    Thanks for both solutions.

    Rick, is it possible you explain about the line

    Data = Split(Join(Split(TotalFile, vbCrLf), ","), ",")

    Sounds a bit complicated to understand it.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4