Member Avatar for dmatos

Hello all, When trying to export save a file i get the following error in my SaveDialog window: The bold line is where the error occurs, says: Object Required

Dim eRuta As String
On Local Error GoTo errores
'dialog.DialogTitle = "Exportar Archivo"
cDialog.Filter = "Excel File (*.XLS)"
cDialog.FileName = "Reporte.XLS"
With cDialog
       
       .Filter = "Excel Files (*.xls)|*.xls"
       
        cDialog.ShowSave
    End With

 [B]   eRuta = frmRutaExcel.dialog.FileName[/B]
    
If eRuta <> "" Then
txtRuta.Text = Trim(eRuta)
End If
  • 3 Contributors
  • 2 Replies
  • 131 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for BitBlt

Can we assume that cDialog is the name of the common dialog control on your form frmRutaExcel? If so, then the bolded line should read:

eRuta = frmRutaExcel.cDialog.FileName
commented: agree. +9
Member Avatar for debasisdas

You have mistyped the common dialog control name.

should be cDialog not dialog.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.