VB - Creating - Relatively Simple Code For An Excel Project
Oct 19, 2009
I'm sorry if this is in the wrong forum or has already been asked, but I'm having a problem creating what should be a relatively simple code for an Excel Project. Essentially, the code is supposed to check if a certain column has Y in it and then copy that entire row onto another sheet and then move on to check the rest of the original sheet. This version of the code seems to do everything but actually populate the cells with the information. Every other attempt I've made has ended with "Application-Based or Object Based Errors". I've worked on this code for a few days now and I just can't seem to get it right. What am I doing wrong?
Here's the code:
Sub PopulateNewSheet()
i = 2
Do While Worksheets("Main List").Cells(i, 2).Value <> 0
[CODE].................
View 1 Replies
ADVERTISEMENT
Apr 23, 2009
I'm trying to use the System.Windows.Forms.MonthCalendar control within a VSTO Excel workbook. I want the MonthCalendar to pop up when I click a button in the ribbon, but so far I can't get the control to display at all.
Private Sub DeliveryDateFromCalendarButton_Click(ByVal sender As System.Object, ByVal e As Microsoft.Office.Tools.Ribbon.RibbonControlEventArgs) Handles DeliveryDateFromCalendarButton.Click
[Code].....
View 2 Replies
Mar 18, 2009
I'm creating an Addin, specifically to MS Project 2007. This Addin create a toolbar with a button that will allow user to export his project to excel sheet in MS Excel 2003 or 2007. My problem is create workbook with worksheet. I already made toolbar and added the button. My button can open Excel Application but i can't add workbook and worksheet.
Code:
<script type="text/javascript">
<!--
Imports Microsoft.Office.Interop
[Code]....
View 5 Replies
Jun 16, 2009
I'm having some problem with VB project in visual studio 2008, when I open or create a new project in VB only code is displayed in the design tab but no GUI and toolbox is greyed out.
View 3 Replies
Oct 6, 2009
I need my app to create a excel file, but I am getting a error running this code. While running this in debug, on the line "xlWorkSheet.SaveAs("C:vbexcel.xlsx")" there is a error saying "ComException was unhandled" and "Exception from Hresult 0x800A03EC"
Imports Excel = Microsoft.Office.Interop.Excel
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object,_
ByVal e As System.EventArgs) Handles Button1.Click
[code]....
View 2 Replies
Jun 10, 2011
Is there anyone can post a simple code using vb,that start building a simple games ?
View 2 Replies
Nov 9, 2010
I can do this using VBA, but I want to be able to create the code using a compiled VB programme, which can then be opened in Excel.
View 1 Replies
Oct 21, 2010
I'm attempting to do a school project dealing with a simple web crawler. I have a form with a web browser control embedded that loads a web page will all the available courses. I have a text box and a button design for a user to search for a specific course by using the four letter department abbreviation. The page that I have loaded has all the department abbreviations as hyperlinks.is it possible to search the page using the four letter abbreviation specified by the user and if the search finds a corresponding hyperlink open it. Then I would use a loop to repeat the process of opening each class offered by that department and obtaining information such as course name, section number and so forth.
View 2 Replies
Apr 25, 2009
I would like to click next to go to another image in a picturebox but I only have one picture box setup to have the new letter displayed in it. I have 26 images to display and need to know how to setup a loop to go through each image? It seems simple but I cannot figure out how to get to the third image, it only goes to the second image and stops. I also need to know how to setup the back button to display the prior image in a picture box.
View 8 Replies
Dec 8, 2010
i am going creating a simple function calculator, but I had to first do a design documentation proposal. I now have to update the project proposal with a storyboard or list of menu and screen items to delineate my proposed user screen and menus.aside from the calculator itself there will not be any menus.I also have to list any user data inputs and outputs my application will require and produce, which i assume i can put any numbers that the user inputs into the calculator and their results.
View 5 Replies
Jun 21, 2010
i want to create a simple POS system, can you tell me how can i hide group of buttons/ controls on the first load of a form and then group of controls will just show after a button is clicked or selected. Also i want to have a display (on same form) of what is selected by the user.
View 3 Replies
Mar 24, 2010
I am a total bginner to vb.net programming. I am trying to make a simple program that allows the user to
1.change desktop background
2.Allows the user to select a boot image listed in the form
3.alows the user to enable disable the task manager,registry editor and control pannel.Replace Windows Boot image (Picture source is a picture box in form)
4.Change XP Start Button Text
5.Disable/Enable Windows Keys
so this is how far I got;
Imports Microsoft.Win32
Public Class Form1
Implements IDisposable
[code]....
View 3 Replies
Feb 21, 2012
I'm suspicious my spouse is cheating. In the past few months he has systematically locked me out of all of his social media accounts shortly after getting a job with a group of female secretaries that travels for a week at a time. He has been dodging or non-communicative when confronted about this.url...
The only way to avoid interaction with antispyware is to create it myself.I understand that copying text or something into an open notepad session or the clipboard is out of the question; however I'm pretty sure that I could create a (fairly) simple script that does the following:[code]I know this is extremely inneficient but this is the most covert way i can think of, a simple wscript that runs on startup and creates these .txt files in an important looking place (windows/config/system/logs/win32 - example)
View 1 Replies
Oct 13, 2011
I am trying to create a simple browser that will be mainly for personal use. I followed a tutorial to create the actual browser; the address bar and the Go button and now I need to create the Home button, Back and Forward button.If I can find the source code for it, I am going to implement it into my sample browser and perhaps?
View 20 Replies
Dec 17, 2008
I dont know wether this is the right place but would i be able to use somthing like streamreader to change a .txt on another computer? If so, how?
View 3 Replies
Apr 14, 2011
I have moderate experience with VB, and am using 4.0 framework with VS 2010 pro.get a specific way i should accomplish a leader board system where it can manually assign points to players and sort them accordingly.
View 1 Replies
May 31, 2010
I am here to write a small database application that will be running in desktop (offline mode).I am using MSAccess 2007 as my database file and trying to write code in vb.net.I used to write the code vb6 an usually had global variables for storing database connection and executing every query from that.I am trying to upgrade myself from vb6 to vb.net.do i need to read some more simple starter books also?
View 3 Replies
Nov 10, 2009
I am just new in visual basic and I was given a task to do a basketball playbook application using visual basic. I am trying to do a simple editor that would allow you to design the plays. How do I implement a picturebox (picturebox1) with an image in it (lets say image1) then when I drag it image1 will appear in another picturebox (picturebox2)with a basketball court background. Then after dragging image1, picturebox1 will now display another image (image2) ready to be dragged also.
View 3 Replies
Aug 1, 2011
What is the simplest and most straightforward way to: Create a local dB with a table with 2 fields (a string, a number) Determine is string s is present in the dB Add a record into the table consisting of a string and number Delete a record based on the string Get the record for a particular string Get the record with the highest number
View 3 Replies
Nov 11, 2009
Im a user of VB 2005. I had a problem with Simply run a project (Even Without any code in it). Indeed when i Creat a new project and i want to run and debug it (with F5). The information box show that cant debug. and because of that, the program may not run.The Message in information box is here (in Appendix).I try it with VB 2008 (But didnt work). After i Reinstall all of VB and Install again, but my problem existed even now.
View 3 Replies
Mar 20, 2012
I am trying my hand at making a simple poker hand analyzer in VB 2010 for a distance education intro to VB course at my school.My goal is to represent the cards in a table array. Rows are suits Clubs/Diamonds/Hearts/Spades and columns are values (A, 1, 2... K). However I have no clue how to design a Sub procedure that will recognize the hand the user inputs and add any possible results to a listbox (fourkind/threekind/pair/flush/straight/ace high straight). I don't understand how exactly I'm supposed to do this. My criteria isn't very strict. I can have a hand with more than one description, like a fullhouse + threekind + pair can all be used to describe one hand.
What I think I need to do is split the entered string to get 5 strings (each is a card). Then somehow find these in the table? I have no idea how to do this and I'm stumped... The instructions loosely call to look for a boolean value where cards(i,j) is set to 1 of the player is dealt card j in suit i. But I do not know how to achieve this.
As you can see my understanding on VB is extremely... basic (no pun intended). It's my first time ever learning a computer language, and I really regret taking this course via distance ed because the instructor and the TA absolutely refuse to communicate with the students. I am trying my best to practically self-teach with the thick text book.
View 9 Replies
Mar 6, 2011
I am currently writing a program in Visual Basic 2008 express edition to read and write to tags on an Omron PLC. I am using the DeviceXPlorer OPC Server V4.1.1.1 program to connect to the Omron PLC. I have made two programs, one is a form program which works fine, two is a windows service program where it does not let me connect to the OPC Server. The connection code is identical, the only difference is the windows service code is called by a timer. The timer works fines and jumps into the connection code, but stops at the line
[Code]...
View 3 Replies
Jun 11, 2012
This is newbie VB question. My son is learning VB and I am learning with him. We have RichEdit control application (non WPF), where we input text, formatting its Style (bold, italic, underline, etc.). Our next task is to save the text together with its attributes into the file. The question is: what type of serialization is preferred at this case?
View 3 Replies
Jul 8, 2010
Can any body tell me why this simple paint project wont work.
View 1 Replies
Sep 13, 2010
I have created a simple project where I have two forms, one a data entry form where a client name, address, city, state and zip are entered into textboxes. Then, the user clicks a button to add all this data to the datatable via a newrow. The second form includes a datagridview to show the datatable. However, I cannot get the code below to work to update the datatable. I have a button to click to check to see if the data is entered and it returns an error that no row exists.
View 2 Replies
Mar 12, 2010
So i'm creating a simple application as an example that is to link to a Access 2007 database.
On my main form i have four listboxes that are correctly attached to the table, I have one for First Name, Last Name, Phone, and School. I added 3 records to the database in Access to see if I could display the records in the listboxes on the form. I found that it was very easy by setting the properties and I have no problem there. I also have a command button that loads a new form for the purpose of adding a record to the database.
Here is my main form (frmMain.vb)...
CODE:
And Here is the code for the form...
CODE:
What i'm looking for is when the user presses the Add button on the frmAddNew form then it needs to close and the new record is listed in the textboxes and saved to the database. Id also like to know all kinds of things i might be able to do with textboxes and databases because i'm trying to learn for a larger project where i'll need to keep track of hundreds of records.
I understand that this is a simple procedure, but i've been spending all night scouring tutorials and getting lost in the msdn library online, so maybe some human input will be better.
View 1 Replies
Jul 4, 2010
Im trying to make a simple send key system on my project but it dosent send to the window in in why ?
SendKeys.Send(X)
My.Computer.Keyboard.SendKeys(X)
View 11 Replies
Jul 12, 2011
I want to start a Windows Forms Project (VB.NET) using a simple text editor like notepad. I'm not interested in creating a button and other controls from scratch, I just want to know how to create a form, initializing controls without using the wizard.how to use command-line to compile the whole project?
View 2 Replies
Mar 6, 2011
I'm a rookie in Visual Basics 2008 and i am trying to make a program to communicate and read tags from an Omron PLC. I am trying to connect to the PLC via devicexplorer opc server, because it can let me read DInts and Reals from the PLC tags. I have referenced Microsoft ActiveX Datas Objects 2.5 Library and OPC DA Automation Wrapper 2.02. I have made some code which connects to the PLC "in a form", but I cannot use the same code and connect through as a Windows Service program.Here is my code,
Public Sub OpcConnect(ByRef Items() As String, ByVal PLCType As Integer)
Dim j As Integer
Dim TempSvrHandles As Array[code].....
Note: this code is run in a timer on the windows service, it connects properly to the "RSLinx OPC Server", but "Takebishi. Dxp.1" (devicexplorer shortcut) exits the sub routine at MyServer.Connect(PLCServer) ' connect to the opc server.
View 6 Replies
Jun 11, 2011
I'm retrieving data from an Excel sheet, using a simple SQL query using a textbox as input to my variable. It works great when I enter an integer to search for (such as 213 for example) but when I put in a mixture of numbers and letters (48A for example) I get the following error: Syntax error (missing operator) in query expression '[P&L]=48A'.
Private Sub MPLS3()
Dim BrNr As String
BrNr = TextBox1.Text
Dim stSQL As String = "SELECT [MPLS Date] FROM [Master Data$] WHERE [P&L]=" & BrNr & ";"
[code]....
View 2 Replies
