Improve company productivity with a Business Account.Sign Up

x
?
Solved

Vb.Net - Excel Deleting Sheets

Posted on 2013-06-04
3
Medium Priority
?
181 Views
Last Modified: 2013-06-07
Good Day Experts!

I have an application here with a TabControl and 21 tabs.  The majority of them output to Excel from a DataGrid. Behind the ExcelOutput button click, I delete the 2 extra sheets that aren't needed before I make the spreadsheet visible.  When I run it locally here in my development environment, I am not prompted with the "Are you sure you want to delete this sheet" messagebox.  However, when I publish it, the User is prompted for each sheet.

Is there a way for them to not see the messages?

Thansk,
jimbo99999
0
Comment
Question by:Jimbo99999
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
Alexander Eßer [Alex140181] earned 2000 total points
ID: 39220303
I suppose, you've done this before calling the delete method (I know, this may be "stupid" question) ;-)

    Application.DisplayAlerts = False

Open in new window

0
 

Author Comment

by:Jimbo99999
ID: 39220326
Hello, thanks for repsonding.  I have not done that...I never knew about it.  I will try it.
0
 
LVL 14

Expert Comment

by:Alexander Eßer [Alex140181]
ID: 39220340
BUT: set back to True once you've done your "work" ;-)
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question