I'm using Visual Studio 2010 and Excel 2007. I'm having difficulty figuring out how to convert an office excel project into a vb.net project. I wanted to take the ugly windows 98 style buttons I currently have in my spreadsheet and replace them with controls on a new tab on the ribbon. I can make it that far, but I didn't anticipate the large gap between languages.
The code below is supposed to take a bunch of information from a windows form and insert it into a new row on sheet12, sort the table of info, and name the range. Right now visual studio show no errors until I actually try to run the code at which point it says "Object reference not set to an instance of an object." regarding the code "oSheet.Rows("1:1").Copy()" I don't think I understand declaring my variables in vb.net.
In my tic tac toe game I'd like there to be three different levels; easy, medium, and impossible. There are 2 forms; the difficulty level form and the main game form. When the game first starts the user will be prompted with the difficulty level form which contains 3 radio buttons; easy, medium, and impossible.
I've coded three different functions based on the difficulty level; easyMove(), medMove(), and impMove(). These have all been coded in the main game form. How could I run the respective function based on the radio button that was selected in the previous difficulty level form?
If it was on the same form it wouldn't be a problem but because it is on a different form I'm unsure of how to do this.
I just started with VB.NET using Murach VB.net 2008 book and i want to make this program for my work, please tell me what knowledge needed to make this program beside VB.NET: want to make a program for my supervisor which Lists the name of every employee in our division. the program should be accessed by any computer in our division using LAN. each employee will have user and pass to enter this program they only can view their data with charts showing their attendance, productivity , etc, supervisor will have master account where can edit the info.the supervisor can send private message like e-mail to each employee. all the info should be saved in database so it can be used to compare the employee activity for each year.
Okay, i've tried httpwebrequest, webclient, and a couple of others methods; using the headers parameter of each to set headers and then either opening a response stream or simply setting the system.net.webclient method to download a response into a string. Put simply, how do I make a simple GET request with a few headers and read the data back! I am very, very stuck in a hole right now..
I am having some problems with manipulating a one dimensional string array in VB.NET and would like My objective is to get 4 variables (if possible) from a file path. These variables are: myCountry, myCity, myStreet, Filename. All declared as string. The file location is also declared as string. so I have:
Dim filePath As String to illustrate my problem, and what I am trying to do, I have the following examples:
1- C:mylocationisUKBirminghamSummer Road his house.txt.
I am working on an application and have encountered difficulty using the response to a message box question. I am trying to call one form if the user clicks yes another form if the user clicks no, please have a look at my code and see if you can see where i am going wrong because no matter whether i press yes or no the frmTransactionMenu is being shown and never the frmExit
Dim response As DialogResult MessageBox.Show("Would you like to complete another transaction", "ANOTHER TRANSACTION ?", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
I am currently developing in Visual Studio 2008 (Visual Basic) and I have no problem reading, editing, saving, etc. to a 2007 Access database that is stored locally using the following code:
Dim NotifyDS As New DataSet() Dim NotifyCon As New OleDb.OleDbConnection NotifyCon.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|DataSettings.accdb" NotifyCon.Open()
Ultimately I am going to be installing this program in my office on multiple computers, but would only like to have one "server" program where the database is installed. All of the other computers will have access to this one database over the LAN. For some reason I am unable to access this remote database file over my LAN. I have tried all sorts of things (including a username and password for the server computer),
I'm not sure if this is really a VB IDE issue, or a more general VS10 issue, but I couldn't find any other relevant category to post in, so here goes!I have several VB projects which I want to use in the same solution in Visual Studio 10. I created a project (& corresponding solution) which will reference them and added the existing projects by right clicking the solution in solution explorer choosing 'Add->Existing Project'. Then I went to the containing project's Properties window and added references to the existing projects, so they could be used by the project.
I'm having a strange difficulty. Here is the order of events:User presses button on form1 New Form object is created for from 2 New form object '.show' command is fired Form 2 opens correctly In the Load Event of Form 2, the form attempts to do various things in a try, catch, finally clause On catch, I close form2 down '.close' as it cannot be used as something has gone wrong with the execution However, my problem is this. It is acceptable for things to go wrong on the from 2 load event which is why I have implemented the try - catch functionality. However, when I close the form2 down as a result of the problem, a real error ocurrs 'Cannot access a disposed object' and the VB IDE refers me to Form1's '.show' event for Form2.
It is almost as if the form hasn't fully 'shown' before I am closing it down. Does anyone have any idea what the problem is here? Do I need to close down Form2 ourside of it's Load event handler so that Form1 thinks it has loaded correctly?
I'm attempting to import an excel spreadsheet into a dataset. The spreadsheet is selected by the user by browsing for a file. I can get it to work properly only if I know the exact sheet name, but it varies from sheet to sheet. I need to tell it to always use the first sheet in the workbook.
I've declared the following at the beginning of my project:
I made a programme through which I get a feed back clicking a button for a future warning date. I am giving the code below so that you can givthe problem is, I have to take 12 DateTimePicker to do that job in a single form which is creating a saving problem means when I click save button it takes long time to save. Now, I thought If I can do it by using TextBoxn a date format would easeup my save problem. Or it can be MaskedTextBox as well. Below is my code if any one can give me the solution.
Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If DateTime.Now > DateTimePicker1.Value.AddYears(1).AddDays(1) Then
Recently I started a project with the goal being to have text that was inputted into a textbox stored within a three dimensional jagged array. The idea is that every time a button is pressed, whatever text that is inputted into the textbox is split into separate elements, where each word occupies its own element in the array. So for example, if a poem were entered into the textbox and the button clicked, each word of the poem would be assigned to a discrete element in the vertical dimension, and each line of the poem assigned an element in the horizontal dimension. After the text is stored into the 3D jagged array, the text should be cleared from the textbox and a counter should then ensure that on the next button press, the new text inputted into the textbox is stored in a discrete element of the array. Below is the code I have written so far, but I know that I am far from having anything might accomplish what I have just described.
SELECT * FROM tbl_Muffins WHERE OvenLoadId IN ( SELECT OvenLoadId
[code]....
The idea of the query is that I want to specify an OrderId, and I want all Oven Loads that have items from that order in them, as well as ALL OTHER ITEMS in those loads, even though they could be from other orders.The query works as expected, but I'm not able to use it for my Crystal Report I've written it for.I have put this query into a User Defined Function, however I'm unable to use a call to that function as a table source in my Crystal Report. I am using Visual Studio 2003 (I know it is old, the client refuses to upgrade).
I am having tremendous difficulty getting word automation to insert a page break in my document. The app is generating letters in word and saving them....the code below shows where I am writing the first page (str.tostring) then all of the code after that are the various ways that I have tried to insert a page break so that it will go to the second page and I can unload information into the second page of the document. [code]
I am having trouble converting this Do Until loop to a Do While loop. Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click calculates and displays the average sales amount Const strPROMPT As String = _
I have the following in vb.net and need to convert it to c#. Seemed rather simple at first but I need to pass in the NamedObject variable as welll which is supported in vb.net but not in c#..
What are my options.
Here is the vb.net - notice the NamedObject
Public Property Datos(ByVal NamedObject As String) As T Get Return CType(HttpContext.Current.Session.Item(NamedObject ), T)
I am trying to convert an MP3 to a wav. The wav file is created, but I am having problems elsewhere. The label is displaying the wrong data("Cancel/Error") and the progressbar is doing nothing. I am using lame 3.98 .exe and a wrapper for the exe. I downloaded the LameShell project from codeproject. Here is a section of the wrapper class. This was originally for resampling a mp3 to mp3.
I'm developing a program to execute powershell from .net app. I found a sample but it uses c# so I'm changing the code to vb.net but I don't know how change the following line:
I found some code on preventing DOS attacks written by Omar Al Zabir thta I would really like to use on a website written in VB.NET.
The code is at the following link -[URL] but is in C# I tried to convert using variios different programs but there seems to be one line that keeps giving me problems.It's the line
var hit = (HitInfo)(context.Cache[key] ?? new HitInfo());
I am converting my project from VB6 to VB.net 3.5 and at one place i have declared private variable a() as variant and i am using some place as b =a(index,0) it will work in VB but gives me error in VB.Net the error is Number of Indices exceeds the number of dimensions of the indexed array.
It is a program on which logic programs can be developed, compiled and downloaded into Programmable Logic Controllers. It is fairly big and complicated and the resulting .exe file is about 2Mb. I need to develop the program further now, and would like to use VB.net. When I try loading the VB6 code into VB.net, it changes all the variables of type Integer and String into type Object. It then states all through the resulting code that the default values are not defined. I assume that if defined as Integer and String variables do not need a default value, it would assume them to be 0 and empty. Any ideas why the program changes the variable types during the converstion? All forms start with 'Option Explicit', so all variables are defined.
I am trying convert a macro for MSProject from VBA to VB to create an add-in. What I am struggling with is the code to set the values of fields on a windows form and how to actually display the form.
What I have so far is:
Dim objProj As Microsoft.Office.Interop.MSProject.Project Dim objTasks As Microsoft.Office.Interop.MSProject.Tasks Dim objTask As Microsoft.Office.Interop.MSProject.Task
the following is brief description of how my project works. GUI is used to collect information from User and validates.have got dll named control-class that pass input data from GUI to Business logic DLL.this dLL connect to the database and saves data.after that,it disconnected and takes the results to the control dll,then to GUI which interprets if the input data was successful or not.Is there a tool that can be used to convert VB6 GUI to .net web forms? am not familiar to vb.net.how do you create reference to vb6 dll or COM from vb.net?
