Como pasa esto de VBA A FIVEWIN

Como pasa esto de VBA A FIVEWIN

Postby jbrita » Mon Feb 13, 2017 2:59 pm

Amigos tengo esto y funciona bien :
local oExcel := CreateObject( "excel.application" )
local oBook := oExcel:Workbooks:Add()
local oSheet

oSheet:=oExcel:ActiveSheet
oSheet:=oBook:Worksheets( 1 )
oSheet:Shapes:AddTextbox(1, 50, 125, 250, 130):TextFrame:Characters:Text = "EMPRESA PRINCIPAL"

ESTO COMO LO PASO A FIVEWIN para manejar los addtbox
Sub AddTextBox()
ActiveSheet.Shapes.AddTextBox(msoTextOrientationHorizontal, 2.5, 1.5, _
116, 145).TextFrame.Characters.text = "This is a test of inserting a text box to a sheet and adding some text."
With Selection.Characters(Start:=1, Length:=216).font
.name = "Arial"
.FontStyle = "Regular"
.size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
range("I15").Select
End Sub


gracias
jbrita
 
Posts: 486
Joined: Mon Jan 16, 2006 3:42 pm

Return to FiveWin para Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 12 guests