Search found 135 matches: vba

Return to advanced search

Re: VBA to FWH

you need donwliad and install it: http://download.microsoft.com/download/9/6/5/9657c01e-107f-409c-baac-7d249561629c/msxml.msi so try it: #include "fivewin.ch"Function main()  ? BBANtoIBAN( "YourStringHere" )ReturnFunction BBANtoIBAN( BBAN )Local xd, cProgI...
by lailton.webmaster
Sun Jun 13, 2010 1:52 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: VBA to FWH
Replies: 2
Views: 817

VBA to FWH

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 ...
by driessen
Sat Jun 12, 2010 11:30 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: VBA to FWH
Replies: 2
Views: 817

Re: scan pc

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 ...
by ukoenig
Thu Apr 01, 2010 8:07 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: scan pc
Replies: 5
Views: 1222

Re: Possible to define Font-Width for Export to Excel ? (solved)

... 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 ...
by ukoenig
Sat Mar 27, 2010 6:27 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Possible to define Font-Width for Export to Excel ? (solved)
Replies: 2
Views: 743

Possible to define Font-Width for Export to Excel ? (solved)

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" ...
by ukoenig
Fri Mar 26, 2010 4:38 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Possible to define Font-Width for Export to Excel ? (solved)
Replies: 2
Views: 743

Re: Working with Excel

Hello Tim,

here you can download the vba language reference of excel 2003

http://www.microsoft.com/downloads/details.aspx?familyid=2204a62e-4877-4563-8e83-4848dda796e4&displaylang=en
by StefanHaupt
Tue Mar 16, 2010 8:24 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Working with Excel
Replies: 21
Views: 8098

Re: Working with Excel

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 ...
by ukoenig
Mon Mar 15, 2010 11:04 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Working with Excel
Replies: 21
Views: 8098

Re: Working with Excel

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.

Thank you.
by TimStone
Mon Mar 15, 2010 3:30 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Working with Excel
Replies: 21
Views: 8098

Re: Working with Excel

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 ...
by ukoenig
Sat Mar 13, 2010 8:30 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Working with Excel
Replies: 21
Views: 8098

Re: Codejock RibbonBar primeras pruebas

... 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
by goosfancito
Sun Apr 26, 2009 1:07 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Codejock RibbonBar primeras pruebas
Replies: 92
Views: 30027

Re: Clase TActiveX mejorada y RibbonBar más fácil

Antonio,

Si soporta oActiveX:Do( "AttachToWindow", oWnd:hWnd ), pero igual no pinta nada :(

Vale la pena que veas el manual "SymbolReference.chm".

He revisado con VBA, pero igual, no encuentro por dónde hacerla funcionar, me quedó grande :oops:
by Cgallegoa
Wed Apr 08, 2009 3:59 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase TActiveX mejorada y RibbonBar más fácil
Replies: 29
Views: 5837

Re: Clase TActiveX mejorada y RibbonBar más fácil

Carlos,

Yo ni siquiera he mirado el manual :-)

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 :-)
by Antonio Linares
Wed Apr 08, 2009 8:58 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase TActiveX mejorada y RibbonBar más fácil
Replies: 29
Views: 5837

Re: Codejock RibbonBar first tests

... 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 ...
by frose
Mon Apr 06, 2009 2:51 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Codejock RibbonBar first tests
Replies: 116
Views: 38359

Re: Codejock RibbonBar first tests

Frank,

> I really want 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
by Antonio Linares
Sat Apr 04, 2009 9:18 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Codejock RibbonBar first tests
Replies: 116
Views: 38359
PreviousNext

Return to advanced search