Que esta mal?por favor
Publicado por vibet (25 intervenciones) el 17/01/2005 22:26:11
como muestro las imágenes??,os dejo parte del código....
Dim i As Integer
Dim xExcel As Excel.Application
Dim wBook As Workbook
Dim cadenaCOD As String
Dim cadenaNOMBRE As String
Dim cadenaCOMENTARIO As String
Dim cadenafoto As Picture
cadenaCOD = Me.lblCodigocli.Caption
cadenaNOMBRE = Me.txtnombre.Text
cadenaCOMENTARIO = Me.txtcomentario.Text
cadenafoto =picture1 'AQUÍ TENGO EL PROBLEMA
Set xExcel = New Excel.Application
xExcel.Workbooks.Add App.Path & "\ACREDITACION.xlt"
Me.MousePointer = vbHourglass
xExcel.Range("c7").Select
xExcel.ActiveCell.FormulaR1C1 = cadenaNOMBRE
xExcel.Range("c9").Select
xExcel.ActiveCell.FormulaR1C1 = cadenaCOD
xExcel.Range("e3").Select
xExcel.ActiveCell.FormulaR1C1 = cadenaCOMENTARIO
xExcel.Range("d4").Select
xExcel.ActiveCell.FormulaR1C1 = cadenafoto
End Sub
Dim i As Integer
Dim xExcel As Excel.Application
Dim wBook As Workbook
Dim cadenaCOD As String
Dim cadenaNOMBRE As String
Dim cadenaCOMENTARIO As String
Dim cadenafoto As Picture
cadenaCOD = Me.lblCodigocli.Caption
cadenaNOMBRE = Me.txtnombre.Text
cadenaCOMENTARIO = Me.txtcomentario.Text
cadenafoto =picture1 'AQUÍ TENGO EL PROBLEMA
Set xExcel = New Excel.Application
xExcel.Workbooks.Add App.Path & "\ACREDITACION.xlt"
Me.MousePointer = vbHourglass
xExcel.Range("c7").Select
xExcel.ActiveCell.FormulaR1C1 = cadenaNOMBRE
xExcel.Range("c9").Select
xExcel.ActiveCell.FormulaR1C1 = cadenaCOD
xExcel.Range("e3").Select
xExcel.ActiveCell.FormulaR1C1 = cadenaCOMENTARIO
xExcel.Range("d4").Select
xExcel.ActiveCell.FormulaR1C1 = cadenafoto
End Sub
Valora esta pregunta


0