Excel access through VB Script

Discussion in 'Software' started by CobolExpert, Jul 15, 2004.

  1. CobolExpert

    CobolExpert Private E-2

    I am having a hard time trying to figure out how to close Excel without it prompting to save. There must be something else or something I need to add to the XL.Application.Quit area. I just can't seem to find it. I do not want the file to save, it's only being used for notification of open files, I just want it to open and close by itself without user intervention.

    I pasted the statement thats giving me issues , any suggestions would be greatly appreciated. Thanks !


    If Rownumber <= 4 Then
    XL.Application.Quit()
    ELSE
    XL.Cells.EntireColumn.Autofit
    XL.Visible = TRUE
    sMsg = "Refresh in-use files?" &VbCrLf
    sMsg = sMsg & "Press Retry to refresh or cancel to go back"
    sMsg = sMsg & " to the main menu."
    If MsgBox(sMsg, vbRetryCancel) = vbRetry Then
    XL.Application.Quit()
    CALL p1100_Tools_PermCheck_Para()
    ELSE
    CALL p0000_Main_Para()
    End If
    End If
    Set XL=nothing
    End Sub
     
  2. NeoNemesis

    NeoNemesis Moutharrhea

    I'm pretty sure you can set that in options directly through a the options menu in Excel. I believe I saw it somewhere.
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds