+ Reply to Thread
Page 3 of 9 FirstFirst 1 2 3 4 5 ... LastLast
Results 31 to 45 of 122

Compare and Find missing rows in two sheets with different Headings and Formats

  1. #31
    Registered User
    Join Date
    12-07-2015
    Location
    Germany
    MS-Off Ver
    2007 2010 2013
    Posts
    58

    Re: Compare 2 workbooks - Empty array error

    Hi shinpencil,

    Yes, I think maybe i guessed that you compare “Compare Caceis.xlsm” sheet “Board”
    With
    “wb2.xls” sheet 1

    _............................

    Sorry but the rest I still do not understand.

    Quote Originally Posted by JackSht_1 View Post
    .......
    You must tell me clearly what it is that is to be done. ( What program am i supposed to run ? )
    And
    You must tell me clearly what the problem is!!!
    And
    You must tell me ( show ) me what you should get when you run the macro. Tell me and show me what should happen.
    ..........
    _.................................................

    I have no idea what this means of from where it come.

    Using Excel 2007
    Row\Col
    A
    B
    C
    D
    E
    F
    2
    Missing order in Lomax
    3
    Redemption IE00B905SX62 26/04/2016
    05.04.2016
    Unit
    261
    4
    Subscription IE00B905SX62 26/04/2016
    05.04.2016
    Unit
    185
    5
    Redemption IE00B905SX62 26/04/2016
    05.04.2016
    Unit
    327
    6
    Subscription IE00B905SX62 26/04/2016
    05.04.2016
    Unit
    4000
    7
    Redemption IE00B9CB6D86 26/04/2016
    05.04.2016
    Unit
    464.4591
    8
    Redemption IE00B905SX62 26/04/2016
    05.04.2016
    Amount
    51000
    Differences

    What is this. What does it mean ?
    How is it related to your problem ?

    _...................................................

    I am very sorry but i do not think I will be able to help if you cannot explain and show better
    I am very sorry.
    Maybe you must find somebody who can translate to English for you
    Most of what you say is totally in understandable.
    Up until now i have mostly just guessed

    Jack

    Maybe i try tomorrow a very last time to help

    You must Try very hard in the meantime to explain better

    and
    show me

    A better file or files showing

    Before

    and
    After

    or screenshots

    http://www.excelforum.com/suggestion...ml#post4501034

    http://www.mrexcel.com/forum/test-he...ml#post4501034
    Last edited by JackSheet_1; 04-25-2016 at 05:44 PM.

  2. #32
    Registered User
    Join Date
    04-07-2016
    Location
    Paris, France
    MS-Off Ver
    MS Office 2010
    Posts
    68

    Re: Compare 2 workbooks - Empty array error

    Yes this is the orders in wb1 which are missing in wb 2, because I only need the difference in wb1 so I erased the different part of wb 2.
    Sorry you need to erase the table that you mentioned above, it is related to others files
    The problem is that it supposed to have no difference in 2 files I sent you
    Last edited by shinpencil; 04-26-2016 at 03:49 AM.

  3. #33
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Compare 2 workbooks - Empty array error

    Quote Originally Posted by shinpencil View Post
    Yes this is the orders in wb1 which are missing in wb 2, because I only need the difference in wb1 so I erased the different part of wb 2.
    Sorry you need to erase the table that you mentioned above, it is related to others files
    The problem is that it supposed to have no difference in 2 files I sent you
    _..................................

    _.........................................................

    Hi shinpencil,
    I am Alan. ( Jack, ( Jacky ) is may Wife! )

    We still do not fully understand...
    I try to help...

    _1)
    Is File “Wb1.csv‎"
    Irrelevant to the current problem?.
    We do not need it?

    _2)
    Is this Irrelevant to the current problem?.
    We do not need it?

    Row\Col
    A
    B
    C
    D
    E
    F
    2
    Missing order in Lomax
    3
    Redemption IE00B905SX62 26/04/2016
    05.04.2016
    Unit
    261
    4
    Subscription IE00B905SX62 26/04/2016
    05.04.2016
    Unit
    185
    5
    Redemption IE00B905SX62 26/04/2016
    05.04.2016
    Unit
    327
    6
    Subscription IE00B905SX62 26/04/2016
    05.04.2016
    Unit
    4000
    7
    Redemption IE00B9CB6D86 26/04/2016
    05.04.2016
    Unit
    464.4591
    8
    Redemption IE00B905SX62 26/04/2016
    05.04.2016
    Amount
    51000


    _.............................

    Please if you want more help from someone:

    Either
    _a) learn to use screen shot tools
    http://www.excelforum.com/suggestion...ml#post4501034
    http://www.mrexcel.com/forum/test-he...ml#post4501034
    Or
    _b) Give me more Files and / or sheets

    and with those to show me:

    _..............

    _1) You Show me What does everything ( all relavant data in all relavent Files ) look like before you run any macro

    _2) You Tell me what should then be done ( what macro is it that should be run ?).

    _3) You Show me what you get after that macro runs. (This will be give the results you get when you run the macro which are wrong) ( I will then repeat that on the data from _1) to see if I get the same results as you )

    _4) You Show me what is right and what is wrong
    Either
    4a)
    For example like this with screenshots

    Redemption IE00B9C98164 26.04.2016 04.05.2016 Ptang
    85
    Subscription IE00B9CB586 26.04.2017 04.05.2016 Pftang
    700
    Subscription IE003837546D86 26.04.2016 04.05.2016 OLE
    4365
    Redemption IE00B9988375X62 26.04.2016 04.05.2016 wigwam
    78
    Subscription IE0047SJ09 26.04.2016 04.05.2016 biscuitbarrel
    63
    This Colour This Colour
    means Correct means wrong
    CORRECT FAUX
    Differences

    Or
    4b) you give me correct and wrong sheets in a File or Files ( upload Files again )

    4b(i)
    This is what is got with the code currently and it is wrong
    Row\Col
    A
    B
    C
    D
    E
    F
    1
    Code Gives This But it is Wrong
    2
    Missing order in Lomax
    3
    Redemption IE00B9DCSJ09 26.04.2016 04.05.2016 Unit
    195
    4
    Redemption IE00B9CB6D86 26.04.2016 04.05.2016 Unit
    61.0714
    5
    Redemption IE00B9CB6D86 26.04.2016 04.05.2016 Unit
    240
    6
    Subscription IE00B9CB6D86 26.04.2016 04.05.2016 Amount
    3900
    7
    Subscription IE00BX7RQ732 26.04.2016 04.05.2016 Amount
    19835
    8
    Redemption IE00BS7K2808 26.04.2016 04.05.2016 Unit
    177.7072
    9
    Subscription IE00B8BS6228 26.04.2016 04.05.2016 Unit
    3946
    10
    Redemption IE00B905SX62 26.04.2016 04.05.2016 Unit
    261
    11
    Subscription IE00BS7K2808 26.04.2016 04.05.2016 Unit
    2399
    DifferencesWrong

    _.....

    4bii)
    You Show me how everything should look like. what you want the code to give you

    Correct Sheet ( Filled in by hand by you. - You Type the results in yourself to show excactly what you want the code to give you )
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    1
    This is what I want the code to give me
    2
    Missing order in Lomax
    3
    Redemption IE00B9DCSJ09 26.04.2016 04.05.2016 Unit
    32
    4
    Subscription IE00B9CB6D86 26.04.2016 04.05.2016 Amount
    3900
    5
    Subscription IE00BX7RQ732 26.04.2016 04.05.2016 Amount
    19835
    6
    Redemption IE00BS7K2808 26.04.2016 04.05.2016 Unit
    177.7072
    7
    Subscription IE00B8BS6228 26.04.2016 04.05.2016 Unit
    3946
    8
    Redemption IE00B905SX62 26.04.2016 04.05.2016 Unit
    261
    9
    Subscription IE00BS7K2808 26.04.2016 04.05.2016 Unit
    2399
    10
    Subscription IE00B905SX62 26.04.2016 04.05.2016 Unit
    185
    11
    Redemption IE00B9CB6D86 26.04.2016 04.05.2016 Unit
    210
    DifferencesCorrect

    _.............................................................................................


    Try to reduce the data as i have done ( also in “wb2.xls” sheet 1 ) to make it easier for us to work with




    _...........................

    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  4. #34
    Registered User
    Join Date
    04-07-2016
    Location
    Paris, France
    MS-Off Ver
    MS Office 2010
    Posts
    68

    Re: Compare 2 workbooks - Empty array error

    1) Yes we need the wb1 because we need to compare wb1 and wb2
    2) No we don't need this result, it relate to another file
    3) Before I run any macro, there has nothing in the "Compare" file. Firstly I need to import the wb1 in the sheet 1 of "Compare" file then compare it to wb2. For 2 wb I have sent, it supposed display the difference but there have no difference at all
    Last edited by shinpencil; 04-26-2016 at 11:06 AM.

  5. #35
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Compare 2 workbooks - Empty array error

    Hi shinpencil,
    I do not think I, or my Wife, can help you anymore.
    I did some tests for you on reduced data.

    I changed your data to this ( Compare___ File ( in code wb1 )

    Using Excel 2007
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    12
    MT502 Ref. Transaction Type Input/Output Transaction Ref. ISIN Code NAV Date Value Date Share Nb. Investment Type Fund Amount (Client Cur.) Client Cur. Fund Amount (Trade cur.)
    13
    Redemption OUT
    6151784
    IE00B9DCSJ09
    26.04.2016
    04.05.2016
    195.00
    Amount
    19193.46
    EUR
    19193.46
    14
    Redemption OUT
    6174269
    IE00B9CB6D86
    26.04.2016
    04.05.2016
    61.07
    Amount
    6113.25
    GBP
    6113.25
    15
    Redemption OUT
    6179051
    IE00B9CB6D86
    26.04.2016
    04.05.2016
    240.00
    Amount
    24024.00
    GBP
    24024
    16
    Subscription IN
    6187108
    IE00B9CB6D86
    26.04.2016
    04.05.2016
    38.96
    Amount
    3900.00
    GBP
    3900
    17
    Subscription IN
    6198301
    IE00BX7RQ732
    26.04.2016
    04.05.2016
    224.00
    Amount
    19835.00
    EUR
    19835
    18
    19
    20
    Board
    _.......

    And this in file wb2.xls ( in code wb2 )

    Using Excel 2007
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    1
    S/R type Order status Fund share code Fund share name Fund name Pricing Date Value Date Quantity Nature Net amount
    2
    Redemption Estimated IE00B9DCSJ09
    26.04.2016
    04.05.2016
    224
    Amount
    19193.46
    3
    Redemption Estimated IE00B9CB6D86
    26.04.2016
    04.05.2016
    2,480.00
    Unit
    6113.25
    4
    Subscription Estimated IE00BRJ
    26.04.2016
    04.05.2016
    14,700.00
    Amount
    1,501,287.48
    5
    Redemption Estimated IE00BS7
    26.04.2016
    04.05.2016
    3.64
    Amount
    369.15
    6
    Subscription Estimated IE00BS7
    26.04.2016
    04.05.2016
    798.8
    Amount
    80,999.59
    7
    Redemption Estimated IE00BS7
    26.04.2016
    04.05.2016
    439
    Amount
    44,515.48
    8
    Subscription Estimated IE00BS7
    26.04.2016
    04.05.2016
    2,399.00
    Amount
    243,263.40
    9
    Sheet1

    _..................

    Then i run the codes given at referenced at the end of this Post

    You then get these results ( in file “Compare_______ ( in code wb1 ))

    Using Excel 2007
    Row\Col
    A
    B
    C
    D
    E
    F
    2
    Missing order in Lomax
    3
    Redemption IE00B9CB6D86 26.04.2016 04.05.2016 Amount
    6113.25
    4
    Redemption IE00B9CB6D86 26.04.2016 04.05.2016 Amount
    24024
    5
    Subscription IE00B9CB6D86 26.04.2016 04.05.2016 Amount
    3900
    6
    Subscription IE00BX7RQ732 26.04.2016 04.05.2016 Amount
    19835
    Differences

    _..........

    Also i added a new sections which pastes out your two Dictionaries to a new sheet ( in file “Compare_______ ( in code wb1) ) ( which it creates the first time around ) so that you can check you data


    Using Excel 2007
    Row\Col
    A
    B
    C
    D
    E
    F
    1
    key data1_Dico.Item(key) key data2_Dico.Item(key)
    2
    Redemption#IE00B9DCSJ09#26.04.2016#04.05.2016#Amount#19193.4600
    2
    Redemption#IE00B9DCSJ09#26.04.2016#04.05.2016#Amount#19193.4600
    2
    3
    Redemption#IE00B9CB6D86#26.04.2016#04.05.2016#Amount#6113.2500
    3
    Redemption#IE00B9CB6D86#26.04.2016#04.05.2016#Unit#2480.0000
    3
    4
    Redemption#IE00B9CB6D86#26.04.2016#04.05.2016#Amount#24024.0000
    4
    Subscription#IE00BRJ#26.04.2016#04.05.2016#Amount#1501287.4800
    4
    5
    Subscription#IE00B9CB6D86#26.04.2016#04.05.2016#Amount#3900.0000
    5
    Redemption#IE00BS7#26.04.2016#04.05.2016#Amount#369.1500
    5
    6
    Subscription#IE00BX7RQ732#26.04.2016#04.05.2016#Amount#19835.0000
    6
    Subscription#IE00BS7#26.04.2016#04.05.2016#Amount#80999.5900
    6
    7
    Redemption#IE00BS7#26.04.2016#04.05.2016#Amount#44515.4800
    7
    8
    Subscription#IE00BS7#26.04.2016#04.05.2016#Amount#243263.4000
    8
    DebugSheet
    _....................

    I hope that helps a little.
    Goodbye, Au Revoir
    Alan. ( and Jacky )


    Codes are here:
    Sub Find_Differences()
    http://www.excelforum.com/showthread...t=#post4372884
    _.....
    And here:
    Function Get_Header_Dico(ByVal header As Variant, ByVal header_line As Long) As Dictionary
    http://www.excelforum.com/showthread...t=#post4372887
    Last edited by Doc.AElstein; 04-26-2016 at 01:42 PM.

  6. #36
    Registered User
    Join Date
    04-07-2016
    Location
    Paris, France
    MS-Off Ver
    MS Office 2010
    Posts
    68

    Re: Compare 2 workbooks - Empty array error

    Okay thank you and your wife anw for your help!

  7. #37
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    47,784

    Re: Compare 2 workbooks - Empty array error

    shinpencil, you have asked for this thread to be deleted.

    We do not delete threads, if you are done with a thread you can Close it using he Thread Tools at the top of the page
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  8. #38
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Compare 2 workbooks - Empty array error

    Hi shinpencil,
    Quote Originally Posted by FDibbins View Post
    shinpencil, you have asked for this thread to be deleted......
    _..You did not get a full answer maybe, but there may be still some useful info here, so no need to delete the Thread. Otherwise the efforts of people helping are totally lost.

    If you try to narrow down a bit / isolate the problem , reduce the test data , then you should be able to get easier at the problem. That will also aid in you getting help.
    In the end I always still guessing exactly what code to run and on which data!!

    _.....
    _ I appreciate that it is very hard for you due to the Language barrier. One last time i will try to help ( This is All similar to what i tried to say before )
    _...........

    Possibly if you still need more help, you could try again to clarify the exact problem – narrow it down, so confine to:

    _ Reduce ( and desensitise possibly ) your test data

    _ Give a code which is giving you a problem.

    _ Say specifically what data the code is running on. Show the results the code gives you that are wrong and give some hand filled in results to show what the code should give you.

    _...........
    If you are able to do that, it may be valid to say the question is not then exactly that of this thread ( Which none of us could determine anyway , lol )

    So you could “start a fresh” in a new Thread.
    Possibly post your new Thread in this Forum., as you did before, if you are able to explain a little better in English.
    Or you could try out your luck in the “Other Languages” Sub Forums
    http://www.excelforum.com/non-english-excel/
    http://www.mrexcel.com/forum/questions-other-languages/

    Important: Include a link in any new Thread to this Thread ( copied from Link in your browser window ) to confirm with Forum Rules
    HTML Code: 
    http://www.excelforum.com/excel-programming-vba-macros/1135724-compare-2-workbooks-empty-array-error.html
    If you should start a new Thread related to this one, then if you Private Message me to give a link to the new Thread , then I will try to take another look. ( The final codes i did for you appeared to work anyway. – but as mentioned i was still unclear exactly what you wanted ! )

    Alan
    Last edited by Doc.AElstein; 04-28-2016 at 11:46 AM.

  9. #39
    Registered User
    Join Date
    04-07-2016
    Location
    Paris, France
    MS-Off Ver
    MS Office 2010
    Posts
    68

    Re: Compare 2 workbooks - Empty array error

    No sorry Alan and Jacky! Thank you so much for your help but I just want to delete a bit of data because some data could be confidentiels.
    In the end I managed to fix it and it worked with 2 files that I posted here, but there another problem with another file. I just want it can work well with all the files I have
    The problem is that the code I have to import the CSV file (35 columns, 80 rows in general) into Excel, it worked well at the beginning but it didn't work this time. There error in the last line. Could you help me plz?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by shinpencil; 04-28-2016 at 08:40 AM.

  10. #40
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Compare 2 workbooks - Empty array error

    Hi
    Quote Originally Posted by shinpencil View Post
    .....
    In the end I managed to fix it and it worked with 2 files that I posted here, ......
    It is always coutious to feedback , tell us, and share your working solution to a problem you have solved with our help
    _...___________________________________________

    Quote Originally Posted by shinpencil
    .......
    I just want to delete a bit of the data because some data could be confidential.
    Sorry if it make you misunderstanding,
    I not me misunderstanging became,
    as I guessed that might be the case, hence my recommendation always:
    Reduce ( and desensitise possibly ) your test data


    To your new problem, ( which as i suggested might of been better in a new Thread, but i give up trying to explain that again !! )....

    So Your Current problem as detailed in Post 39
    http://www.excelforum.com/showthread...t=#post4374374
    _......
    Again you are making it difficult, not giving precise information or a full code.
    But once again I try..
    you have many problems in your code given in that post #39:

    _ 1) you are using one method of three that i know of to “get at” a workbook.
    http://www.excelforum.com/excel-prog...ml#post4227458

    You chose the Third way referrenced in that above Thread. This one:
    Set WB = GetObject(__________________)

    This by default make the file invisible. ( you cannot see it ) Maybe you want that.? – But in any case it does make it difficult to see what is going on!!!

    1a) If you must use that then change this to

    Wb.Close False

    to

    Wb.Close False
    Set Wb = Nothing

    This is good practice, and you will also see that after Set Wb = Nothing the File is no longer to be seen in the VBA Project Window.

    _.....................

    _2 ) I would recommend instead you do:
    Either:
    Please Login or Register  to view this content.

    Or

    Use a different method to “get at” your file,
    http://www.mrexcel.com/forum/excel-q...xcel-file.html

    such as this:

    Please Login or Register  to view this content.
    _................................

    If you use either of those two options you will see immediately your Current problem:
    Using Excel 2007
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    1
    MT502 Ref. Transaction Type Input/Output Transaction Ref. ISIN Code NAV Date Value Date Share Nb. Investment Type Fund Amount (Client Cur.) This Fund Amount (Trade cur.) Last NAV Date NAV Exch. Rate client / trade
    2
    SUB IN
    6326091
    IE00B6
    20160427
    20160503
    28
    M
    340
    entire
    340
    20160422
    118.4668
    1
    3
    SUB IN
    6353232
    IE00B5
    20160427
    20160503
    60.4
    P
    71
    column
    71
    20160425
    118.1284
    1
    4
    RED OUT
    6353300
    IE00B6
    20160427
    20160504
    66
    P
    875
    is empty.
    8755.28
    20160425
    132.6557
    1
    5
    RED OUT
    6355465
    IE00B6
    20160427
    20160504
    11
    P
    1539
    So CurremtRegion
    153
    20160425
    132.6557
    1
    6
    SUB IN
    6355997
    IE00B6
    20160427
    20160503
    24
    M
    2928
    will Fail
    2928
    20160425
    118.0422
    1
    7
    8
    9
    10
    11
    12
    Yous have no Data near here !!!
    Sheet1

    _3 ) So, Look at that screen shot above and consider:

    _3a) (i)
    You are attempting to get at that data using the .CurrenRegion Property applied to the Cell A12.
    Range("A12").CurrentRegion
    I explained previously to you that
    .CurrentRegion
    Returns a new Range object of a “box” encompassing all cells “connected” to the original Range object, which is
    "A12"
    In this case. There is clearly no cells with data connected to A12 !!! so you will not “Capture” Any data. !!!

    To refer to your data Range
    You must use
    Either
    Wb.ActiveSheet.Range("A1").CurrentRegion ' ' But also, as i said before, this will not work, when as in this case you have a complete empty column which effectively “isolates” what it after the empty column
    Or alternatively
    Wb.ActiveSheet.UsedRange ‘Note for this to work the only data ( ever ) in your file should be that which you wish to “capture”
    so better for your files may be
    Please Login or Register  to view this content.
    _.....

    _3a)(ii) It is very unwise to rely on the Implicit default of a Range object in such a code line which is to return Values. You should specifically use the .Value Property thus
    Insted of
    CurrentRegion or UsedRange
    You are wise to do this:
    Currentregion.Value or UsedRange.Value

    _...................................................................


    _4) You have a typo in your. Resize Property part at the end when pasting out.
    .Resize(UBound(Arr), UBound(Arr, 2))
    Is incorrect. The following is correct
    .Resize(UBound(Arr, 1), UBound(Arr, 2))
    ( by luck this may have worked, but only in this case as
    UBound(arrIn(), 1)
    defaults to
    UBound(arrIn())


    _..........
    So making all those corrections for you in the code I give you below: ( Note I assume at the time of running the macro your Active Sheet is in the Workbook in which the macro is in, and also the Active Sheet is that in which you paste the data.)

    Please Login or Register  to view this content.
    The code given here
    http://www.excelforum.com/showthread...t=#post4374563
    now seems to work. It does not error and pastes your data as shown in next Post: Post #41

    Alan
    Last edited by Doc.AElstein; 04-28-2016 at 12:14 PM.

  11. #41
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Compare 2 workbooks - Empty array error

    Results For post #40 above.

    Using Excel 2007
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    12
    MT502 Ref. Transaction Type Input/Output Transaction Ref. ISIN Code NAV Date Value Date Share Nb. Investment Type Fund Amount (Client Cur.) Fund Amount (Trade cur.) Last NAV Date NAV Exch. Rate client / trade
    13
    SUB IN
    6326091
    IE00B6
    20160427
    20160503
    28
    M
    340
    340
    20160422
    118.4668
    1
    14
    SUB IN
    6353232
    IE00B5
    20160427
    20160503
    60.4
    P
    71
    71
    20160425
    118.1284
    1
    15
    RED OUT
    6353300
    IE00B6
    20160427
    20160504
    66
    P
    875
    8755.28
    20160425
    132.6557
    1
    16
    RED OUT
    6355465
    IE00B6
    20160427
    20160504
    11
    P
    1539
    153
    20160425
    132.6557
    1
    17
    SUB IN
    6355997
    IE00B6
    20160427
    20160503
    24
    M
    2928
    2928
    20160425
    118.0422
    1
    CSVImport

    _.......................

    Code Again:
    Please Login or Register  to view this content.
    Alan
    Last edited by Doc.AElstein; 04-28-2016 at 01:38 PM.

  12. #42
    Registered User
    Join Date
    04-07-2016
    Location
    Paris, France
    MS-Off Ver
    MS Office 2010
    Posts
    68

    Re: Compare 2 workbooks - Empty array error

    Hi, sorry for the late reply, the code worked well at the beginning but another problem appears: I have the subscript out of range error and it highlight this line
    "nature = data1(i, header("Investment Type"))"
    Could you view it for me plz?
    Last edited by shinpencil; 05-04-2016 at 09:10 AM.

  13. #43
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Compare 2 workbooks - Empty array error



    Once again you are not giving enough information for anyone to be able to help you.
    Encore une fois, vous ne donnez pas assez d'information pour quiconque d'être en mesure de vous aider.

    If you want help
    Si vous voulez aider

    You must post the complete code that is not working
    Vous devez envoyer le code complet qui ne fonctionne pas

    You must give us test data on which to run that code. The test data should be reduced in size to the minimum to demonstrate the problem and the test data should be desensitized.
    Vous devez nous donner des données de test sur lequel exécuter ce code. Les données d'essai doivent être réduites en taille au minimum pour démontrer le problème et les données d'essai doivent être désensibilisés.

  14. #44
    Registered User
    Join Date
    04-07-2016
    Location
    Paris, France
    MS-Off Ver
    MS Office 2010
    Posts
    68

    Re: Compare 2 workbooks - Empty array error

    Sorry here is the code. It's basically the same code I just modified it a little:
    Please Login or Register  to view this content.

  15. #45
    Registered User
    Join Date
    04-07-2016
    Location
    Paris, France
    MS-Off Ver
    MS Office 2010
    Posts
    68

    Re: Compare 2 workbooks - Empty array error

    I hit the debug button and got the subscript out of range error, it highlight the line "nature = data1(i, header("Investment Type"))" but none of the element is empty.
    And here the input code:
    Please Login or Register  to view this content.
    Last edited by shinpencil; 05-04-2016 at 09:43 AM.

+ Reply to Thread
Page 3 of 9 FirstFirst 1 2 3 4 5 ... LastLast

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