i need to know step by step.why it is not working .right know i did comment this line set excl=Nothing.but still it is not working .additional i want to address each cell Through Vbcode to make Purchase order.So that excel report should come automatically.Kindly let me know the idea.why even excel is not comming .it is comming and going automatic.it should not stay at the screen.Kindly let me know the idea.Any help would be highly appreciated.
Code:
Private Sub btPrint_Click()
Dim excl As Excel.Application
  Set excl = New Excel.Application
'  Set excl = CreateObject(Excel.Application)
      excl.Visible = True
     ' Set excl = Nothing
End Sub