improper printing of vaSpread....

[BlueByte]

hi!
am trying to populate a vaSpread form & then
print it.the printout prints partial data
(first column data only).also, am getting the following error in the log file.

Line 16: Property OleObjectBlob in vaSpread1 had an invalid file reference.

how do i fix this reference error?

thnx,
bluebyte

 

[geeteshk]

try selecting all and say print selected data

 

[BlueByte]

hi!
wud u pls suggest wot methods shud be
used...
my code is on the lines of:

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Load Form_print
With Form_print.vaSpread1
.PrintJobName = "Acknowledgement Letter"
.PrintBorder = False
If CLng(Text_tot_nof_trfdds.Text) > 1 Then
.Text = "Our Ref. No. : " & UCase(Text_comp_code.Text) Else
.Text = "Our Ref. No. : " & UCase(Text_comp_code.Text) & "/" & txtIn_type.Text & "/" & temp
End If

.FontName = "Times New Roman"
.FontSize = 12
.FontBold = False
.Text = " " & Text_pincode
'Dim rc As Integer
rc = .SaveToFile("saveall.ss2", False)
.Action = 13
tb.Close
'MsgBox "Printing Done"
End With
sbr_EndForm Form_print
Screen.MousePointer = 0
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''
this is printing partial data....


regards,
bluebyte

 

[BlueByte]

hi!

Line 16: Property OleObjectBlob in vaSpread1 had an invalid file reference.

how do i fix this reference error?

i need to fix this urgently....
pls help asap.

thnx,
bluebyte

 

[geeteshk]

beyond me sorry!