I have an Excel 2000 spreadsheet that is being accessed from the web. It opens in a browser window. The user fills out the form and clicks the "submit" button which then copies the excel spreadsheet into an email message and the user clicks "send". When this action is completed I want the Excel document to close automatically.
I've tried Application Quit but in the browser it doesn't work, the user is taken back to the completed form and has to click the X at the top of the browser window to get out.
Can someone please help with how I should approach this?
I've tried Application Quit but in the browser it doesn't work, the user is taken back to the completed form and has to click the X at the top of the browser window to get out.
Can someone please help with how I should approach this?