Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!



How do I get form to close after executiVB script?

By ChrisCPbucc ·
This simple vbscript executes but the form window stays open. I would like it to quit completly after executing. It is run as an EXE file. I am new to this. Any help please?

Private Sub Form_Load()
'******VBScript to open excel spreadsheet, update cell, save then close
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("C:\excelhdrconv\espre2a.xls")
objExcel.Application.DisplayAlerts = False
objExcel.Application.Visible = True 'True
End Sub

Private Sub cmdClose()
Unload Me
End Sub

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

hmm what you have looks right

by markp24 In reply to How do I get form to clos ...

what you have should work,
maybe try ending like this
end sub

i searched online and found this

hope those help

Collapse -

Reponse To Answer

by ChrisCPbucc In reply to hmm what you have looks r ...

Excellent! thanks, the END statement did the job. Thanks for the additional links. they are quite helpful also.

Related Discussions

Related Forums