Hello, Here is VBA-code to convert a traditional banking account number to IBAN : Public Function BBANtoIBAN(ByVal BBAN As String) As StringDim xd As ObjectSet xd = CreateObject("msxml2.domdocument.4.0")xd.Load ...
Hello Otto, You can use a VBA-Script => save the Code to : PingAll.vbs Call from Command-Line, or use Winexec : CSCRIPT pingall.vbs >> results.txt OPTION ExplicitDIM cn,cmd,rsDIM objRootDIM intFailed, intSucceededDIM strPingset ...
... a normal Font, it is not possible to change the Width, like we can do in Our Applications. We have to use it like shown in the Screenshot : The VBA-Code : oSheet:Shapes:AddTextEffect( 7, "My Headline", "Arial Black", 36, .F. , .T., 20, 50 ):Select() http://www.pflegeplus.com/pictures/Excelexp1.jpg ...
Hello, I'm busy, testing the Excel-VBA-Commands. The Font-Objects are defined like : oSheet:Cells:Range( "A1:C2" ):Font:Name := "Arial" oSheet:Cells:Range( "A1:C2" ):Font:Size := 26 oSheet:Cells:Range( "A1:C2" ...
Hello Tim, I started with a Excel-project. Each lesson shows step by step the possibilities, to use VBA from inside FWH. It starts with a customer-list and get more complicated from Lesson to the next. The 1. Lesson is nearly finished and works fine. I will still add different ...
I follow your example perfectly. I was looking for a command reference for Excel programming ( you suggested VBA ) which would allow me to see the available options and expected parameters.
Hello Tim, You have to know more about VBA ( Visual-Basic for Application, NOT EASY ! ) I created for a Customer of mine many Exel-Sheets from inside the FWH-Application to show how it works and Prg-Structure, a Example ( In case You need english ...
... el codejock asi como lo tenes en el vb para inspeccionar? Gracias. Inspeccionando facilmente las propiedades de CodeJock desde Microsoft Word (VBA) para aprenderlas :-) http://img25.imageshack.us/img25/4921/captureg.png
Desde Microsoft Word, abres VBA (Visual Basic for Applications) y tiene un inspector de classes. Y ahi puedes ir viendo datos, metodos y eventos. Es bastante intuitivo
... to know, how Lailton, Richard, or who else has discovered this know how <You can inspect all properties, methods and events from Microsoft Word VBA: viewtopic.php?p=78087#p78087 Thank you for the tip, but IMO it's more efficient to use the Codejock help file!? I was reflecting to the technic ...