• #31 by tpanos on 30 Jun 2010
  • Hi Alfaman,
    I tried again both versions (2003 and 2007). It works OK.
    Try to close Excel, reopen it, not only the excel file and reload.
    After, load MF and launch excel.

    I am in the forum.
  • #32 by tpanos on 30 Jun 2010
  • Did you enable macros on the excel file?

  • #33 by alfaman on 30 Jun 2010
  • I'm using Excel 2003 so I am not sure I need to - or how to do it.
  • #34 by tpanos on 30 Jun 2010
  • I think they are by default enabled.
    Tell me what happened exactly after reloading Excel and the excel file.
  • #35 by Maddox on 30 Jun 2010
  • Hi
    This is looking very good, I think I'm really there.

    One thing you send about was

    "Your trigger in MF will always read cell_Sheet1_A(sel_index*3+1) as before."

    I don't use that formula normally so a bit cloudy on this. The value of this is 0 because the cell is blank, I changed it to cell_Sheet1_A(sel_index*3) and that lands on sel_name. I did a test trigger and it worked well, but bit confused on how to link triggers to selections.

  • #36 by alfaman on 30 Jun 2010
  • Hi Theodore,

    I added an extra sheet so I hope this did not upset it.

    Well now when I am opening it I am getting a "Runtime Error 9 - Subscript out of range - but this did not happen before (it did on several occasions on the previous version.

    If I click "Debug" it takes me to the line:

    For k = 1 To Workbooks(MFPWorkBookName).Names.Count


    Public Sub DefineCellNames()  

    (I saved the sheet with the same name as I opened it from the zip file)

    But I cannot connect MF pro to the sheet now because unlike 10 mintures ago it is now opening book2 again instead of connecting to the open book.
  • #37 by Maddox on 30 Jun 2010
  • I'm getting the same error as you now that I saved it and reopened it. This was with a different file name. Using 2007 aswell if that helps.
  • #38 by tpanos on 30 Jun 2010
  • In this excel file MFPtoExcel2007_V2.xlsm (or MFPtoExcel2007_V2.xls) we have to define the Workbook file name in Sub DefineGlobalParams

    MFPWorkBookName = "MFPtoExcel2007_V2.xlsm"

    change accordingly if you renamed the file.

    if the error occurs again, click debug and pass the mouse over

    For k = 1 To Workbooks(MFPWorkBookName).Names.Count

    on MFPWorkBookName (write me its value) and in the immediate window in VBA


    Did you add your cell names?

  • #39 by tpanos on 30 Jun 2010
  • if your sheets carry more cell names, just delete the my xl_ cell names (not MFPCell name) via the name manager and save the file. They will be recreated by DefineCellNames when you save the file.

    Perhaps we might web conference so that I see the problems live.

  • #40 by Maddox on 30 Jun 2010
  • ahha that's fixed it  :)

    I should be fine for the time being. Thanks so much for your hard work./me sticks kettle on
  • #41 by alfaman on 30 Jun 2010
  • Message is MFPWorkBookName=empty
  • #42 by tpanos on 30 Jun 2010
  • Alfaman,
    tomorrow we will have a web conference to see in live where is the problem if it still exist.
    I will start a meeting in WebEx and I will invite you. When are you available?

  • #43 by alfaman on 30 Jun 2010
  • Thanks I really appreciate your help.
    Probably 6pm UK time would be good.
  • #44 by Maddox on 09 Jul 2010
  • Having a problem with a memory leak using this sheet. Starts fine but I've had it running for 2 days now and the memory is at 600mb for MFP, the excel.exe is 17mb.

    Any ideas what might be wrong?
  • #45 by tpanos on 09 Jul 2010
  • Hi Maddox,
    MFP sends dde commands. Nothing special as it conceives ImportMFP as a string, parsed and send to excel via DDE.
    I don't know of course if there are side effects in custom cells.
    May be we will ask support for that.
    Does excel increase its memory when in use?

    I will publish next week a new excel file with some patches.
    1. Cell Names are auto-managed, you do not have to delete them by hand
    2. sub DefineCellNames() is easier to add new names

    Best Regards,