Author Topic: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!  (Read 48714 times)

Tags:
  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #30 on: Wed, 30 June, 2010, 18:47 »
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.

  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #31 on: Wed, 30 June, 2010, 18:50 »
Did you enable macros on the excel file?


  • Élite
  • Posts: 475
  • Karma: +6/-0
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #32 on: Wed, 30 June, 2010, 19:11 »
I'm using Excel 2003 so I am not sure I need to - or how to do it.

  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #33 on: Wed, 30 June, 2010, 19:20 »
I think they are by default enabled.
Tell me what happened exactly after reloading Excel and the excel file.

  • Élite
  • Posts: 103
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #34 on: Wed, 30 June, 2010, 19:21 »
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.


  • Élite
  • Posts: 475
  • Karma: +6/-0
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #35 on: Wed, 30 June, 2010, 19:33 »
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

in

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.

  • Élite
  • Posts: 103
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #36 on: Wed, 30 June, 2010, 19:45 »
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.

  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #37 on: Wed, 30 June, 2010, 20:03 »
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

?Workbooks(MFPWorkBookName).Names.Count

Did you add your cell names?

Theodore

  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #38 on: Wed, 30 June, 2010, 20:21 »
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.



  • Élite
  • Posts: 103
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #39 on: Wed, 30 June, 2010, 20:37 »
ahha that's fixed it  :)

I should be fine for the time being. Thanks so much for your hard work./me sticks kettle on

  • Élite
  • Posts: 475
  • Karma: +6/-0
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #40 on: Wed, 30 June, 2010, 20:49 »
Message is MFPWorkBookName=empty

  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #41 on: Wed, 30 June, 2010, 22:12 »
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?


  • Élite
  • Posts: 475
  • Karma: +6/-0
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #42 on: Wed, 30 June, 2010, 22:41 »
Thanks I really appreciate your help.
Probably 6pm UK time would be good.

  • Élite
  • Posts: 103
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #43 on: Fri, 09 July, 2010, 11:51 »
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?

  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #44 on: Fri, 09 July, 2010, 12:20 »
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,

Theodore