FiveTech Software tech support forums

nageswaragunupudi wrote:There is
oRange:Find( target, ......... )
method available
Please check for this method in VBA online help.
(Open excel and click help )

Thanks Roa,

That's where I was looking for.

There is
oRange:Find( target, ......... )
method available
Please check for this method in VBA online help.
(Open excel and click help )

EMG, I looked in my documentation for xHarbour, and FiveWin and cannot find OrgDefaultArg(). Maybe you have mistyped the function. The correct name is OleDefaultArg() It's inside rtl.lib. Use it for empty parameters: MyOleObj:MyOleMethod( Param1, OleDefaultArg(), Param3, etc. &#...

EMG,

I looked in my documentation for xHarbour, and FiveWin and cannot find OrgDefaultArg().

I include this in my project and my link fails. What Lib is this in?

Also how does this work, it is not obvious how to utilize this function.

Thanks,

Byron...

No, you have to use positional method. You can use OLEDEFAULTARG() for the empty parameters.

EMG

I run across this when using Microsoft Office programs where I am utilizing OLE to control them. How do I call this: oExcel:ActiveWorksheets:QueryTables:Add(Connection:="TEXT;C:\MyFile.txt", Destination:=Range("$A$1")) The way the parameters are passed is different, is there a wa...

Hi, I found on the MicroSoft-site an example how to change the 'Subject'-field it in VBA Dim properties As Microsoft.Office.Core.DocumentPropertiesproperties = DirectCast(Globals.ThisDocument.BuiltInDocumentProperties, _    Microsoft.Office.Core.DocumentProperties)properties.Item("Subject").Value ...

... else user = ""            endif            return( user )       } Visual Basic example MS-Excel contains Visual Basic for Applications (VBA) that allows for scripting to control the Excel application, but also to control other applications through OLE Automation. The following is the ...

Dear Sir, I use VBA to access dbf data via apollo engine. I am unable to replace dbf to the record appended successed. Anyone, please kindly teach/help me to correct the code as hereunder and kindly tell where I can find the sample ...

Maybe there are methods or DATA like

oword:UserDefinedPlaces
Please try with VBA to find out the syntax.

path is working for me.

MsgInfo( oword:path )

Best regards,
Otto

Antonio:

en VBA si hace la conexión sin marcar error.

en fwh en esta linea se sale sin marcar ningun error.

oServidor:= TOleAuto():New("MSSOAP.SoapClient30")


fw10.7, xhb, bcc582, Win732b


Saludos,
Mauricio

Mauricio,

Si tienes instalado Office, prueba a crear ese mismo objeto desde el VBA de Office (desde un macro de Word, por ejemplo).

Thank you very much for your help.

It works perfectly.

Great.

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...

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 ...