Comments for ThisIsNotATest http://tom.paschenda.org/blog Just another WordPress weblog Wed, 08 Sep 2010 00:17:15 +0000 http://wordpress.org/?v=2.2.2 Comment on Dynamic Dialogs in Excel VBA by Alison http://tom.paschenda.org/blog/?p=16#comment-701 Alison Tue, 20 Jul 2010 18:33:55 +0000 http://tom.paschenda.org/blog/?p=16#comment-701 Hello-Thanks for this post. I will definitely be needing it! I wonder if you can help a beginner tho: I am running a piece of code in a macro. At a certain point in a Loop in the code, I want the userform to pop and for several of its textboxes to be populated with information from the sheet or from the macro (whichever proves easiest. The data will be different each loop iteration, and the user will respond to the new data. How do I get this info into the textboxes in the userform? I don't think I can pass a value to the userform initialise event, so is there some other way to pass a value to a userform?. OR is there a counter of some sort I can use (within the userform's code) which will count how often its been opened/initialised/activated before (during the macro run, obviously reset to 0 when macro finished looping). Hope this makes sense. Any help will be much appreciated! Hello-Thanks for this post. I will definitely be needing it! I wonder if you can help a beginner tho:
I am running a piece of code in a macro. At a certain point in a Loop in the code, I want the userform to pop and for several of its textboxes to be populated with information from the sheet or from the macro (whichever proves easiest.
The data will be different each loop iteration, and the user will respond to the new data.
How do I get this info into the textboxes in the userform?
I don’t think I can pass a value to the userform initialise event, so is there some other way to pass a value to a userform?.
OR is there a counter of some sort I can use (within the userform’s code) which will count how often its been opened/initialised/activated before (during the macro run, obviously reset to 0 when macro finished looping).
Hope this makes sense. Any help will be much appreciated!

]]> Comment on Dynamic Dialogs in Excel VBA by Pinu http://tom.paschenda.org/blog/?p=16#comment-694 Pinu Tue, 08 Jun 2010 19:31:56 +0000 http://tom.paschenda.org/blog/?p=16#comment-694 Great, That Solves a big problem of mine. Thanks. Too Good! Just one suggestion, If you add to the code The procedure to add dynamically a UserForm then I think the next person looking for the solution can stop his search here. Anyways great stuff! I have just one more problem, if you can help. I have 2 workbooks. A.xls and B.xls. Macro codes are password protected. But not the files. So I can open A.xls can work and run macros but cant view the code as the code is password protected. Now i am working in a new project in B.xls and I need a code from A.xls. The code is in class Afileclass of A.xls. 1st problem: I need to create a object of Afileclass class in B.xls and access all public function. 2nd problem: Is there a way if I dont want the A.xls to remain open. 3rd problem: I want to pass parameters while calling the proc. Thanks for your help. Great, That Solves a big problem of mine. Thanks. Too Good! Just one suggestion, If you add to the code The procedure to add dynamically a UserForm then I think the next person looking for the solution can stop his search here. Anyways great stuff!

I have just one more problem, if you can help.
I have 2 workbooks. A.xls and B.xls. Macro codes are password protected. But not the files. So I can open A.xls can work and run macros but cant view the code as the code is password protected.
Now i am working in a new project in B.xls and I need a code from A.xls. The code is in class Afileclass of A.xls.
1st problem: I need to create a object of Afileclass class in B.xls and access all public function.
2nd problem: Is there a way if I dont want the A.xls to remain open.
3rd problem: I want to pass parameters while calling the proc.

Thanks for your help.

]]> Comment on Dynamic Dialogs in Excel VBA by Edward http://tom.paschenda.org/blog/?p=16#comment-693 Edward Tue, 25 May 2010 12:12:15 +0000 http://tom.paschenda.org/blog/?p=16#comment-693 Hi thanks for the example - very helpful. I can get _Click and _Change events to work but not _AfterUpdate. (ie use the same object, like a combobox but replace _Change with _AfterUpdate) Is there a reason for this & is there a solution? Many thanks Hi thanks for the example - very helpful. I can get _Click and _Change events to work but not _AfterUpdate. (ie use the same object, like a combobox but replace _Change with _AfterUpdate)
Is there a reason for this & is there a solution?
Many thanks

]]> Comment on Dynamic Dialogs in Excel VBA by Toby http://tom.paschenda.org/blog/?p=16#comment-691 Toby Fri, 23 Apr 2010 12:37:12 +0000 http://tom.paschenda.org/blog/?p=16#comment-691 I cannot thank you enough for this article. I have been beating my head against code walls looking for the solution to this problem! The number of articles I trawled through looking for this answer has been frustrating, especially since the majority of them did not work on forms, but only worksheets and involved letting VB modify it's own code (bad security practice IMHO). Your publishing of this information is very much appreciated, and I now know where to go first to look for solutions to my problems! Awesome job. I cannot thank you enough for this article. I have been beating my head against code walls looking for the solution to this problem! The number of articles I trawled through looking for this answer has been frustrating, especially since the majority of them did not work on forms, but only worksheets and involved letting VB modify it’s own code (bad security practice IMHO).

Your publishing of this information is very much appreciated, and I now know where to go first to look for solutions to my problems! Awesome job.

]]> Comment on Getting Qt and Ruby (=QtRuby) running on Windows XP by Matthew Borgeson http://tom.paschenda.org/blog/?p=38#comment-665 Matthew Borgeson Wed, 24 Mar 2010 15:20:55 +0000 http://tom.paschenda.org/blog/?p=38#comment-665 Long time since a response, just wanted to let you know I did have the wrong version of installed! Funny thing was, I had just gotten it running and then found myself using my Linux dev box more often at home for a Rails app for work and have yet to touch it since...*sigh* the trials and tribulations of gainful employment! Thanks again for everything- Long time since a response, just wanted to let you know I did have the wrong version of installed! Funny thing was, I had just gotten it running and then found myself using my Linux dev box more often at home for a Rails app for work and have yet to touch it since…*sigh* the trials and tribulations of gainful employment!

Thanks again for everything-

]]> Comment on Getting Qt and Ruby (=QtRuby) running on Windows XP by Karolus http://tom.paschenda.org/blog/?p=38#comment-641 Karolus Fri, 12 Mar 2010 17:35:31 +0000 http://tom.paschenda.org/blog/?p=38#comment-641 Thanks. I simply copied all DLLs from the Qt 4.3.4 directory to the directory where the Ruby bin files reside. That worked. Err ...a mistake on my part: I was testing with Microsoft Windows XP, not NT. Cheers, Karolus Thanks.

I simply copied all DLLs from the Qt 4.3.4 directory to the directory where the Ruby bin files reside. That worked.

Err …a mistake on my part: I was testing with Microsoft Windows XP, not NT.

Cheers,

Karolus

]]> Comment on Deploying Ruby (and QtRuby) Applications by admin http://tom.paschenda.org/blog/?p=41#comment-635 admin Tue, 09 Mar 2010 05:30:53 +0000 http://tom.paschenda.org/blog/?p=41#comment-635 Hi Jorge! Thanks for the information on deploying and the list of required dlls. I think that is very helpful. Regarding your question of creating a standalone exe, I suggest to ask the question in the ocra forum. Usually you get an answer pretty quickly. The reason why even "Hello World" needs all those Qt dlls is that Qt Ruby is one big chunk. According to the kde-bindings mailing list, Richard Dale is planning to divide Qt Ruby into separate modules (but there is no schedule for that). Best Regards Tom Hi Jorge!
Thanks for the information on deploying and the list of required dlls. I think that is very helpful.

Regarding your question of creating a standalone exe, I suggest to ask the question in the ocra forum. Usually you get an answer pretty quickly.

The reason why even “Hello World” needs all those Qt dlls is that Qt Ruby is one big chunk. According to the kde-bindings mailing list, Richard Dale is planning to divide Qt Ruby into separate modules (but there is no schedule for that).
Best Regards
Tom

]]> Comment on Deploying Ruby (and QtRuby) Applications by Jorge Daniel Sampayo Vargas http://tom.paschenda.org/blog/?p=41#comment-634 Jorge Daniel Sampayo Vargas Tue, 09 Mar 2010 02:57:17 +0000 http://tom.paschenda.org/blog/?p=41#comment-634 It appears than my last comment was cut probably due to a limit of chars: Even if the program doesn’t use opengl or sql, it needs the dll’s. My solution was to generate an installer with NSIS, to copy all these dll’s(>26mb) to the install dir where it is my exe generated by ocra (1mb). I hope this helps someone. Sorry about my english. Does anyone know of a way to be able to generate the exe with orca including all of these dll's? Sometimes a standalone exe is more welcomed than an installer. Best Regards. Jorge Sampayo. It appears than my last comment was cut probably due to a limit of chars:

Even if the program doesn’t use opengl or sql, it needs the dll’s. My solution was to generate an installer with NSIS, to copy all these dll’s(>26mb) to the install dir where it is my exe generated by ocra (1mb).

I hope this helps someone. Sorry about my english.

Does anyone know of a way to be able to generate the exe with orca including all of these dll’s? Sometimes a standalone exe is more welcomed than an installer.

Best Regards.
Jorge Sampayo.

]]> Comment on Deploying Ruby (and QtRuby) Applications by Jorge Daniel Sampayo Vargas http://tom.paschenda.org/blog/?p=41#comment-633 Jorge Daniel Sampayo Vargas Tue, 09 Mar 2010 02:50:36 +0000 http://tom.paschenda.org/blog/?p=41#comment-633 Hello, I have the same problem that Narasimha, I'm using ocra, not rubyscript2exe I created a simple helloWorld in QT with a pushbutton, deploy the exe, it runs correctly in my system, but in any other computer it says that it doesn't found libsmokeqt.dll It appears than that dll is installed with qtruby4 windows installer: http://rubyforge.org/tracker/index.php?func=detail&aid=13995&group_id=181&atid=761 And here it is described for what it is used: http://www.qtcentre.org/threads/19831-What-is-the-use-of-libsmokeqt-dll-for-windows The library in my system is in "C:\WINDOWS\system32\libsmokeqt.dll" If I copy that library to the client computer (it works putting it in the exe folder, it is not necessary to copy it to system32), then it ask now for QtCore4.dll, so I started copying one by one to fill the requirements of the powerful HelloWorld program. I copied all the dll's from "C:\Qt\4.3.4\bin" This is the list of dll's needed to be able to run the HelloWorld: . |-- Qt3Support4.dll |-- QtAssistantClient4.dll |-- QtCore4.dll |-- QtDesigner4.dll |-- QtDesignerComponents4.dll |-- QtGui4.dll |-- QtNetwork4.dll |-- QtOpenGL4.dll |-- QtScript4.dll |-- QtSql4.dll |-- QtSvg4.dll |-- QtTest4.dll |-- QtXml4.dll `-- mingwm10.dll Even if the program doesn't use opengl or sql, it needs the dll's. My solution was to generate an installer with NSIS, to copy all these dll's(>26mb) to the install dir where it is my exe generated by ocra ( Hello,

I have the same problem that Narasimha,

I’m using ocra, not rubyscript2exe

I created a simple helloWorld in QT with a pushbutton, deploy the exe, it runs correctly in my system, but in any other computer it says that it doesn’t found libsmokeqt.dll

It appears than that dll is installed with qtruby4 windows installer: http://rubyforge.org/tracker/index.php?func=detail&aid=13995&group_id=181&atid=761

And here it is described for what it is used:
http://www.qtcentre.org/threads/19831-What-is-the-use-of-libsmokeqt-dll-for-windows

The library in my system is in “C:\WINDOWS\system32\libsmokeqt.dll”

If I copy that library to the client computer (it works putting it in the exe folder, it is not necessary to copy it to system32), then it ask now for QtCore4.dll, so I started copying one by one to fill the requirements of the powerful HelloWorld program.

I copied all the dll’s from “C:\Qt\4.3.4\bin”
This is the list of dll’s needed to be able to run the HelloWorld:
.
|– Qt3Support4.dll
|– QtAssistantClient4.dll
|– QtCore4.dll
|– QtDesigner4.dll
|– QtDesignerComponents4.dll
|– QtGui4.dll
|– QtNetwork4.dll
|– QtOpenGL4.dll
|– QtScript4.dll
|– QtSql4.dll
|– QtSvg4.dll
|– QtTest4.dll
|– QtXml4.dll
`– mingwm10.dll

Even if the program doesn’t use opengl or sql, it needs the dll’s. My solution was to generate an installer with NSIS, to copy all these dll’s(>26mb) to the install dir where it is my exe generated by ocra (

]]> Comment on Qt Open Source 4.3.4 and Visual Studio by admin http://tom.paschenda.org/blog/?p=28#comment-632 admin Sun, 07 Mar 2010 14:51:23 +0000 http://tom.paschenda.org/blog/?p=28#comment-632 Hi Mike! It looks like there is something wrong with your environment variables. Make sure, that the include-variable is set correctly, so windows.h can be found. You can print the contents of the include-variable using echo %include% Also try to use the Qt command prompt or the Visual Studio command prompt (you can find them in the start menu). They should have the environment variable preset correctly. Hth Tom Hi Mike!
It looks like there is something wrong with your environment variables.
Make sure, that the include-variable is set correctly, so windows.h can be found.
You can print the contents of the include-variable using
echo %include%
Also try to use the Qt command prompt or the Visual Studio command prompt (you can find them in the start menu). They should have the environment variable preset correctly.
Hth
Tom

]]>