In excel i use the Goal Seek Function but i want to use it on a Visual Basic.net Application.
I need the formula used to calculate the Goal Seek or something that can replicate the Function.
Thanks For all the help !
3 Answers Found
It seems your question is a development question more than a visual studio editor question, So next time please post your question in
Visual Basic general forum.
I think you may try Crystal report to use this feature.
I will close this thread by marking my reply as answer, if this does not help, feel free to let me know and unmark it.
Please unmark it if it does not help, and mark it if it helps.
I am new to programming and have just finished one of my first projects. I would like to possibly sell this application, but I need to figure out how I'm going to get the app. protected.
I plan on selling the program as a digital download and was wondering what the steps would be to issue serial licenses to the people who will purchase it.
Can anyone please direct the first few steps? It would be greatly appreciated.
Aaron C.Read more...
Hello, I am 14 and I hope to be a software programmer when I am older, hopefully a game programmer.
Here is an example of a game made with it.)
About a year ago I started some C++ tutorials and saw that it was very complicated. I only made a few console programs that would ask you your age and print it back to you ect...
Recently I picked up Visual Basic 2010 Express, Visual C# 2010 Express, Visual C++ 2010 Express, and XNA Game Studio 3.1.
I have done the Visual Basic picture viewer, maze game, and maths quiz tutorials and they worked, so I have a VERY BASIC understanding of Visual Basic so far. I have also made a few basic console apps in C++.
If I want to start a programming language to eventually become a game developer, should I:
Start With Visual Basic .NET, then move on to C# (without XNA), then C# with XNA, then C++.
Start with C#, then move on to C# with XNA, then C++, ignoring Visual Basic .NET.
This would be done over a number of years, and I am willing to pick up books and dedicate time to these.
Please help me choose what to do (:
What are my options when I need serial port support but have the first version of Visual Studio. Net 2002 where there is no serial port support. What version of Visual Studio will I need.
Thank youRead more...
This is my first post here, and it looks like a great community, with lots of generous help available!
I am just delving into ASP.NET and the .NET framework and it appears to be a little daunting at first.
What is the deal with having to choose a language for ASP.NET?
Isn't ASP.NET already a web server language itself?
Isn't C# more for offline development anyway?
I'm just trying to get a feel here, because this concept appears to be rather new to me!
Any help is greatly appreciated!
I had VB2008 Express on my machine, registered.
I previously installed and used MS Visual Basic 2010 Express beta 2 ENU on XP SP3 machine.
Now it asked for Registration. So I tried. It complained I sould update to full 2010 release. So I tried this.
It didn't succeed. It complained about old beta 2 ENU Components that need to be uninstalled.
I removed everything named 2010 in Systems software.
I updated .net 4.0 beta 2 to full .Net 4.0.
Still it doesn't install. It still complains about old beta 2 ENU components I now cannot find.
What else should I do?
I think this Issue is relevant to all that installed VB 2010 beta 2 ENU
Thank You for any advice!Read more...
I'm writing a small program to manipulate an Excel spreadsheet.
I need to be able to AutoFilter a certain 'list' of telephone extensions in my company.
I'd like to sort by three extensions, lets say, 116, 119, and 122.
This is exceptionally easy inside of Excel as:
ActiveSheet.Range("$A$1:$N$34").AutoFilter Field:=1, Criteria1:=Array("116" _
, "119", "122"), Operator:=xlFilterValues
However, I cannot get this to work in Visual Basic 2010.
I tried the following:
Dim myAl(0 To 2) As String
myAl(0) = "116"
myAl(1) = "119"
myAl(2) = "122"
oSheet.ListObjects.AddEx(Excel.XlListObjectSourceType.xlSrcRange, oApp.Range("$A:$H"), , Excel.XlYesNoGuess.xlYes).Name = "Calls"
However this resulted in the Excel sheet only filtering the final entry in the array.
Anyone able to offer some insight into what I'm doing wrong?Read more...
I just work out my interface and coding (attached)
the problem is.. i have 1 btnDelete but still not working... i want the Delete button clicked to delete the whole row record..
anyone can gimme example?
the code :
Public Class Form1
Private headers() As String = Nothing
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
SetUpHeaders("Folder Path,Folder Name,Photo Name,Date Taken,Location,Weather Condition")
txtSource.Text = "C:\textfile\records.txt"
Private Sub SetUpHeaders(ByVal headerLine As String)
headers = headerLine.Split(","c)
For Each h As String In headers
Dim column As New ColumnHeader()
column.Text = h
column.Width = 102
Private Sub AddToListView(ByVal dataLine As String)
Dim data() As String = dataLine.Split(","c)
Dim it As New ListViewItem()
it.Text = data(0)
For i As Integer = 1 To data.GetUpperBound(0)
Private Sub WriteHeaders(ByVal writer As StreamWriter)
Dim s As String = headers(0)
For i As Integer = 1 To headers.GetUpperBound(0)
s &= "," & headers(i)
Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click
Using sr As New StreamReader(Me.txtSource.Text)
Dim inputLine As String = sr.ReadLine()
While Not inputLine Is Nothing
inputLine = sr.ReadLine()
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Using sw As New StreamWriter(txtSource.Text)
For Each it As ListViewItem In lvwData.Items
Dim outputLine As String = it.Text
For i As Integer = 1 To it.SubItems.Count - 1
outputLine &= "," & it.SubItems(i).Text
Private Sub lvwData_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lvwData.SelectedIndexChanged
Dim its As ListView.SelectedListViewItemCollection = lvwData.SelectedItems
For Each it As ListViewItem In its
cboPathName.Text = it.SubItems(0).Text
txtFolderName.Text = it.SubItems(1).Text
txtPhotoName.Text = it.SubItems(2).Text
txtDateTaken.Text = it.SubItems(3).Text
txtLocation.Text = it.SubItems(4).Text
cboWeatherCondition.Text = it.SubItems(5).Text
Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
Dim its As ListView.SelectedListViewItemCollection = lvwData.SelectedItems
its(0).SubItems(0).Text = cboPathName.Text
its(0).SubItems(1).Text = txtFolderName.Text
its(0).SubItems(2).Text = txtPhotoName.Text
its(0).SubItems(3).Text = txtDateTaken.Text
its(0).SubItems(4).Text = txtLocation.Text
its(0).SubItems(5).Text = cboWeatherCondition.Text
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim it As New ListViewItem
it.Text = cboPathName.Text
Private Sub txtDateTaken_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs)
If Not IsDate(txtDateTaken.Text) Then
e.Cancel = True
MsgBox("Please enter a valid date")
After store/save the detail in text file I may well to delete or modify information on the text file. And i'll need to have the facility to search the file for folder paths to photographs that meet the following simple criteria:
• A specific file name.
• Names of files that contain a specific string.
• A specific date.
• A range of dates.
• A specific location where the photographs was taken.
• A particular weather condition.
maybe i need to do this by a new windows form....
How do you extract source code from a VB.NET .EXE file?Read more...
I am a newbie to CCF, as the subject implies. This means I have installed the beast (CCF 2009) and all the stuff it is dependent upon. I have read a bit about it.
My ultimate goal is to integrate legacy applications with a web page. For now, I'd like to actually see something happening.
Is there some place online where one can get at a simple move by move tutorial on how to use CCF from withing Visual Studio (I'm using Visual studio 2005) to run a simple legacy application (I don't care if the simple application it is form with a text box hastily concocted by myself in VB or whatever) from within the agent desktop (the "thing" that I believe will visually aggregate my stuff)?
Thank you very much, to whoever can help me. It seems a great technology, but simple tutorials seem to be scarce...
Jorge de AbreuRead more...
I am a freelancer, and am currently looking to migrate all my code on different technologies to a single Source Control system. I am currently deliberating between choosing SVN or TFS Basic (I considered Git also, but that does not seem to have good Windows
& VS integration at this point).
I primarily develop from a single Win 7 machine, which would have both the Source Control server and the clients setup. Is TFS a worthwhile option in my scenario?
Also, is TFS bundled with VS 2010 Ultimate setup??Read more...
Looking to learn VB.net (beginner here) for the object oriented programming of the program I use for work (Civil3D 2010). Those forums state learn VB.net. I just bought MS VB 2008 Step by Step and going thru the chapters. The questions
I have are. Is there a difference between (and in programming) VB2K8 vs VB.net? Am I wasting my time with this book? If VB.net is what I want, which book would be good for me to start with? I also bought the MS Visual C# 2008, which
I planned on reading after the VB 2K8. Would like to get on the fast track for Vb.net programing.Read more...
can i know what .net framework is required for my application that has been developed under Microsoft Visual Basic 2010 Express.Read more...
I already have installed Visual Studio 2008 but was configured to go with SQL Server 2008, thus the menu for VS 2008 will be for SSIS, SSRS. How can I add Visual C++ and Visual Basic?
i like to know why they didn't think of maybe someone wants to make a program that can write a CD or DVD
i searched the entire net trying to find a single program made by visual basic .net
i found 4 but non of them worked they had some problems the last one made windows to write the files instead of it
i just want to make a program that can burn files please make a code or a program that can do that or try to add something like that in vb.net
I am a student and i am making a windows application in vb.net 2005. My project requrement is to print form's specific area and also provide left, right, top and bottom margin. It will also print in multi page if it require. For
that i used Microsoft PrintForm Component 1.0. But it is not working.
So for my problem please provide me code solution or any other component.
Thanx and regards
Abhishek DubeyRead more...
I want to terminate a process by calling TerminateProcess via "kernel32".
I builded up the code below but there is an error. How can I fix that?
PrivateDeclareFunction TerminateProcess Lib"kernel32" (ByVal hProcess AsLong, ByVal exitcode AsLong) AsLong
PublicDeclareFunction OpenProcess Lib"kernel32" (ByVal dwDesiredAccess AsLong, ByVal blnheritHandle AsLong, ByVal dwAppProcessId AsLong) AsLong
PublicDeclareFunction CloseHandle Lib"kernel32" (ByVal hObject AsLong) AsLong
PrivateConst PROCESS_ALL_ACCESS = &H1F0FFF
Sub RandomName(ByVal id AsInteger)
Dim hprocess AsLong
Dim exitcode AsLong
hprocess = OpenProcess(PROCESS_ALL_ACCESS, False, id)
exitcode = Process.GetProcessById(id).ExitCode 'InvalidOperationException was unhandled: Process must exit before requested information can be determined.
Sub ButtonCall_Click() Handles Button2.Click
I need to remove VB .Net Standard 2002 installation from a XP SP3 laptop I used for development. Unfortunately I threw away the installation disk which came with a VB MSPress Manual. I have read and followed the advice in KB Articles 312383,
320114 and 319714 with no success. The MSIs would not even run in admin mode. Has anyone removed this product without the installation disk? Is there a source for a detailed list of the files and folders I must manually remove?
When none of the appraoches in the KB articles helped, I uninstalled all the Versions of Framework and got closer to getting rid of the app. It still asks for the source disk or gives a missing file error when I attempt to use the MSI file
to directly remove it.
Much of the product software appears to be installed in separate VS and VB subfolders in "Program Files" I could delete these folders then run MSIZAP to clean up the Registry. Does this sound reasonable?
Hi, I'm trying to upgrade my VB6 program to VB 2008 express
and the IDE is VERY SLOW. I saw patch for this but it cannot be install
because it's for the complete Visual Studio and I only have the Express Edition.
What Can I do?
I am trying to build my own website and realized that it would be a big help to also create my own vb program to enable me to embed tags with simple clicks of buttons. I am having trouble getting my vb code to be compatible with html code (I keep getting
vb syntax errors).
Here is what I've tried:
<strong>'Inside of a button:
Textbox1.text = "<html tag example></html tag example>"</strong>
So I am looking for a quick code snippet to make html tagging compatible with my vb code.
Here is an example of a program that I'm trying to code my project similar to:
Any code snippets would be greatly appreciated!
I am using Visual Studio 2005, the information is listed as below.
Microsoft Visual Studio 2005
Version 8.0.50727.762 (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727 SP2
When I rebuild the project, an error occuried.
Error 3 The assembly 'Microsoft.VisualBasic, Version=188.8.131.52, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' is not registered for COM Interop.
Please register it with regasm.exe /tlb.
So I followed the http://support.microsoft.com/kb/316163
to register microsoft.visualbasic.dll, and the types registered successfully.
However when I switch back to Visual Studio .NET or Visual Studio 2005, and then rebuild the project. The error is still coming to me.
Help will be appreciated.Read more...