I have a problem when I try to execute this VBA DLL Example. I can not read any code in VBA editor of Excel and the program doesn't work. I have already copy the MemBrainDll.dll" into the folder "C:\Windows\System32".
Thank you in advance for your attention.
I've already heard about that problem and there's also a corresponding thread in the German section of the Board.
It seams to be related to Excel versions > 2003 (the VBA example has been created using Excel 2000). What version of MS Office/Excel are you using?
I'll further investigate into this. Hopefully I will be able to dig down to the root cause of the problem and provide hints to work around.
Alternatively I'll try to get access to an Excel version > 2003 and re-create the example.
I'll let you know as soon as I have further insight...
I've tried to translate the solution somebody found for this problem in the German section of the board. It seems to be necessary to add the path to the Excel file to your 'trusted locations' like described here:
http://office.microsoft.com/en-us/excel ... 91033.aspx
Please let me know if this worked.
Original German thread:
Thanks and regards
I'll let you know once I have found out what the problem is.
Does that mean that you still see no code at all? Or has the behaviour at least changed?but unfortunately it still doesn't work!
I have written a Script to create, train and validate some nets.Then I have done also another script in visual basic to analyze the dates that MemBrain gives (these .csv files). Now my idea is to combine these two scripts in order to have just one program, which create, train, validate the nets and analyze all the dates. Is it possible to execute the membrain script in Visual basic? I've already told you that I can not see this VB example at all. It would be nice if you could help me.
Thank you in advance.
no, the dll has no scripting functionality, i.e., you can not run MemBrain scripts from within Excel. However, you may be able to do it the other way round: MemBrain scripting does allow you to start external applications. Thus, you could try to launch Excel from within the MemBrain script after the data generation is finished. I don't know what the parameters to Excel must be to cause it to automatically start a VBA program but I assume that this should be possible.
Does this help? If you manage to do so it would be great if you quickly could post the approach here!
your idea was great. I used the function ShellExecute( "open" , "path of the excel file that contains the macro ", "") and then I save all the VB program as a macro. This macro is saved as Auto_Open(), that means that the macro is executed automatically as soon as Excel is opened. In this way I could combine both scripts.
When I finish all the program, I am going to upload in the forum.
Thank you very much!!!