next »

[joe loyzaga]

opens an excel worksheet - but when I call xl.quit it stills prompts with a dialog box whether to save - but I don't want it EVER to save - is there a way to open read only? or force no save?


   Set xl = CreateObject("Excel.Application")
   If Err.Number <> 0 Then
      MsgBox "Failed to initiate Excel." & vbCrLf &  "This operation requires Excel to be installed.", vbCritical
      Exit Function
   End If

   ' Open specified workbook   
   xl.Workbooks.Open(sFileName)
   If Err.Number <> 0 Then
      MsgBox "Specified Excel file '" & sFileName & "'." & vbCrLf & "Make sure the file name is correct.", vbCritical
      xl.Quit

[Gautham Maroli]

you can use:
xl.DisplayAlerts = false

[Tarun Lalwani]

Well if you make a change then the prompt would come. To avoid you should close the workbook before quitting

xl.Workbooks.Close False 'Close and don't save