I have a macro running in Autodesk Inventor that opens and closes an Excel workbook.When the macro closes the workbook a message box prompts whether I want to save or not.I dont.How can I close the message box without save and continue my macro.Or better yet, how can i keep this message box from even coming up?I've tried this where "oExcldoc" is the workbook:
oExcldoc.close (savechanges =false)
it freezes up inventor.
I am using the MsgBox Function as a help on my program to notify users of unusable entries in my program. After the MsgBox pops up, and the user clicks on either 'OK' or 'Cancel', the program need to clear the box that the bad data was entered in, and continue with the program. What I am trying to do I guess is keep the program from returning unusable values by informing the user of entries that will return such values. But, where I am running into a problem is in when I click on OK or Cancel, the program continues as if nothing was called as a result of the MsgBox info being thrown.
Here is the code I have so far, mind you that I have used several of the other MsgBox codes to no avail.
I think what I need to do is have a line of code that calls my "textbox.clear" if certain criteria are met. but when I tried this, the program did not return to my GUI, it simply ran with a value of "0" in the "textbox.text" that the clear was called on.
When I do the try/catch method in my vb.net project I will try the code I want and when it can't do it, i make a message box right after the catch method. The thing is that it will show the message box, and then another message from the program itself. Like for example, I have here a MySQLException, and when i click ok on the message box, it will show another one right after showing the exception itself. How would I be able to get rid of this so the user doesn't have to see this, and the program can continue.
View 2 RepliesI have an access 2007 database that I have been developing a front end for in vb.NET for the past 3-4 weeks using vs2008 in a Windows 7 enviroment. Yesterday I started getting an error of "Your network access was interrupted. To continue close the database and then open it again." This happens in the Form Load on the line:
gotData = Me.LeaguesTableAdapter.Fill(Me.LeaguesSeasonsPlayersDataSet.Leagues)
I can go into access 2007 and view all the data fine and in vs2008 I can view the server explorer and browse the tables. However, under data sources if I try and preview the data, I get the same error message as before. What confuses me the most is that the database is not stored on a server is just stored in My Documents. It was origionally stored on my desktop pc but has been copied to the My Documents on my laptop. But as I mentioned previously it has been working fine and has just all of a sudden started throwing this exception by my Try Catch routine. FYI I have tried creating a new DB and importing the tables from the old DB but this hasn't solved the problem either.
In vb dot net, Windows form details should save if I press enter key should save and close and escape key should close without save
Currently it happens on onclick event of a button of Save and Cancel, but I wish the keyboard events also work
There is a feature I used to have in zOS assembler environment that I'd like to know if it's available in VS2010 (VB .net). In assembler it is called macro language :
First, I define a set of instructions and save it as a macro (ex: MYMACRO)
Second, anywhere in my source code I can call the macro (by adding the line "MYMACRO")
Third, when i launch the compilation/link step, the compiler implicitly replaces all the "MYMACRO" lines in the source code by the content of MYMACRO defined in first step.
Is there a feature like this in VS2010 ?
Example:
Content of macro CONTEXTSTART with a parameter &id
Try
ContextManager.Start(&id)
[CODE]........................
How would i go about closing my openfiledialog in the event that there is an error[code]...
View 12 RepliesIs there away to make a kind of message box, there pup up in maybe 3 second, and then close down auto.
View 2 RepliesI'm have a program (GUI) that interfaces with excel to execute macros. We're using Microsoft.Office.Interop.Excel to call/run the macros and this works great.What I can't figure out is a good way to cancel the macros from the GUI.One idea we had was to use the excel.application variable that runs the macros to write a "stop" value to a specific cell in the workbook, and in the macros (they are all mostly loops), check for the "stop" value in that cell. This crashes my GUI with this The program '[2188] BVLReports.vshost.exe: Managed' has exited with code -336589910 (0xebf00baa).And excel gets tied up, and won't respond. I know how to Exit Sub from within the macro if the "stop" value exists, so I don't need answers on how to check/cancel from inside the macro. Any ideas on a better way to write this "stop" value or a better way to cancel the macros externally?
View 2 RepliesFor now i have not finished my code and as i am still really playing with .net to learn the different functions how can i close the windows application down after the ok only message box has been clicked? here is the code so far:
[Code]...
I am trying to show a message box when a user clicks the red cross in the top right hand corner of the screen (to close the current form) and I want to code the OK and Cancel buttons so that when the user clicks OK butto the form closes. This is what I have
[Code]...
I have a password form that contains a load of buttons. The user has to enter a four digit, numeric, password to procede. They do this by pressing one of 10 number buttons on the screen, the keyboard isn't used. If they enter the wrong password an error message pops up (this isn't using the error tool I just added a message box msgbox("Error Code #638492") or something) if the user doesn't enter a password, after 5 seconds (I use a timer called Timer1 with an interval of 5 seconds) the form closes and it goes back to the previous page.
My only problem is when I close the form using Me.close(), the message box is still displayed. And if the message box is still displayed it doesn't work. The form is miminized (I have the application in full screen) so this is very bad. What I need is to simulate the enter key press then close the form so the enter key is pressed, the messagebox close then the password form closes.I can do this using SendKeys.Send("{ENTER}"). Here's the sub I use:
[code]...
However, if I don't have the 'Close()' line of code in the message box closes as it should. If I don't have the message box open and I don't use the SendKeys.Send("{ENTER}") then the close() line works perfectly and close the password form as it should?
How to auto close webbrowser popup alert message in vb2008?
View 4 RepliesI have a form with a listbox. I have controls on the form that can add items to the listbox with the click of a button. I already have the save file, open file dialogs working properly but I want to add something else that works with them. Lets say I open a file and the listbox adds all the strings from the file. Now, lets say I add something to the listbox and instead of saving the file, I just close the whole form. How do I make my program ask if i want to save the changes to the file when it is about to be closed? (I only want it to ask that IF there are changes to the file).
View 9 RepliesI have 2 Forms.Form 1 is main and holds a button that should show msgbox with date that is selected on datetimepicker which is on Form 2. Date shown on msgbox should be in short format (dd.MM.yyyy.).On program start datetimepicker should be reset to today and msgbox should show today date unless user selects another date on Form2. If user goes to From 2 and changes date Form 2 should save new value and msgbox should show it after button click on form1. How do i do this?I made myDate parameter in settings of type "DATE" and i didn't set a value.on form1 load i have:my.Settings.myDate = Today on Form2 load i have: datetimepicker1.Value = my.Settings.myDate on Form2 closing i have: my.Settings.myDate = datetimepicker1.Value
This sets date on picker correctly, but when i go to form2 and change value, then close form2 and reopen it it still shows date that i have chosen, but msgbox shows initial value.
I am trying to save settings on close I have the following code
[Code]...
I have edited the control properties of the checkBox and bound the checkBox with settings value under application settings when I load the form the checkBox is always checked = false ? what have I done wrong?
I have tried the code below to use a message box to provide an option, but whether I click on the yes or no button the yes code is always executed and shows "Saved" in the text box.
[Code]....
How can I save what a label says after closing? I know i would have to use My.Settings but I dont know what "type" to use I want something like
-My Button changes label name
-I close program
-After I restart my program, the label name is the same as when I closed it.
I have a form with textboxes for input. I have coded the Exit button to display a message box that asks the user if they want to save any data in the textboxes before exiting the program:
Private
Sub btnExit_Click(ByVal
sender As System.Object,
ByVal e
[code]....
The question I have if the textboxes are blank (nothing has been entered), how do I code the Exit button to close the program without displaying the message box asking the user to save the data.' Save the numbers. Call the btnSave_Click procedure.
I need to save an XML file with close to 10k child nodes and i need to know which approach is best for it.[code]This is a web application so the choice is very important.
View 5 RepliesWhenever I try, the save file dialog comes up when I hit No and same when I hit Cancel....
If My.Settings.SaveSTS = False Then
MsgBox("Do you wish to save your changes?", MsgBoxStyle.YesNoCancel)
If MsgBoxResult.Yes Then
If My.Settings.OnceSaved = True Then
Dim writer As New IO.StreamWriter(SaveName)
[Code] .....
I need code to save the opened excel book (save as) and close it.
View 1 RepliesI want to save the opened excel book and close it. My code is given below but i found errors in that code .
xlBook.SaveAs (strTargetFile)
xlBook.Saved = True
xlBook.Close
I've tried my.settings examples and the arn't working such as:
Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
[code].....
This is the first time that I will have ever actually published a program and I have a question about when it goes into 'real use' Right now I have string variables that sets the values of a few text boxes that can be edited and 'saved' (the variable values change to the new input).
When I publish the program will these values be saved in the variables after the program is closed then re-opened? Or is everything reset when the program is restarted? And if it is all reset, is there anything internal (aka not a xml file or something) that will hold the data and keep the changes?
How can I supress the save/discard message on my Webcontrol1 on my form?
View 3 RepliesI'm working on this advanced web browser with my friend, and we made a favorites feature. So, it works and all that, but, after I close the executable file, it doesn't save anything!
[Code]...
My application is suppose to save the information that I put in the application that is in a listbox in form2. All the information is in form1, but I got it to save it in the listbox in form2 and I can see it when I load up the form2. Im suppose to make 10 different list for it, (it says it should be in arrays, but I dont know how to do it) and I should be able to save them everytime I put a new one in, but when I put a new list in the listbox and close the application and then reopen it, its erased, how do I save it and keep it in the lstbox so it doesnt get erased?
View 13 RepliesI have VB.net code (2005) that updates an Excel (2003) file but on close I get a pop up from Excel when my code is trying to close it. How can I close and save changes and not get the pop up? ("Save Changes Made").
I tried this:
vb
xlWorkBook.SaveAs(Filename:=excelFileName2, FileFormat:=Excel.XlFileFormat.xlExcel3)
But it renamed the "Sheet1" tab and I got more pop ups from Excel.
i had this working and i foudn the info on this forum, but i cant for the life of me renemebr how to do it, and searching for the thread all i can find is this:
[URL]
Which is not it, the method i used only involved a few clicks per item to set up and it made it so what ever selection was chosen in a combobox for example was saved, and then that selection was loaded on the apps next run, i know i had to do something in the application setting/databinding area of the properties.