I am trying to build an app that can search column A in an excel document (with textbox control). In column B, I have info about the column A items. When a column A item is searched, I would like a textbox (or similar) to display info about it from column B.
View 6 Replies
im trying to design a program where a user inserts text into some text boxes, and selects an item from a dropdown box, and clicks add, i want it so when they click add, it puts the data from the text boxes into an excel worksheet, so say, textbox 1 is product, put product in A1, the second would be cost so put the cost in B1, but the product type in C1(this is the drop down box) and then clear the visual basic form, so the user can enter a second set, and then when they click add, it adds the information into A2, etc, etc.
View 2 RepliesMe Again, Can anyone tell me how to go about using Visual Basic 2010, on getting file information off of My CD'S/DVD'S as I have Many of them with No titles written on them.basically i would like to insert a CD or DVD into my computer and when i click a Button, A textBox will have all the files from the CD or DVD. and then i could print the list and keep a record of my CD/DVD.
View 8 RepliesFor the application I am making, I want a unique identifier (a weak one is fine, just something that would hopefully tell two computers apart). I think I found the right value for the job in the registry, but for some reason it does not want to read intothe program am going after the following key:HKEY_LOCAL_MACHINESOFTWAREMICROSOFTWINDOWS NTCURRENTVERSION ----> ProductIDThe code I am using to attempt to do this is as such:My.computer.registry.getvalue("HKEY_LOCAL_MACHINESOFTWAREMICROSOFTWINDOWS TCURRENTVERSION","ProductID","x") (that last one is just because I need to return some sort of string)However..... I only ever get X returned, and I'm not sure as to why. I tested this with other keys in LOCAL_MACHINE in case it was somehow protected and they worked
View 11 RepliesI would like to be able to read a column of numbers from an Access database into a VB.NET program and then manipulate that data.For example I have a column of numbers and want to add them up and then take the averageThe maths is not a problem but how do I read the column of data into the program. I know how to do this if I first export the Access data into a CSV file, but
View 11 RepliesI've got the following txt file:
[code]...
Now I want that presented in the listbox with the semicolon and it should be aligned per column so that the numbers, the names, the prices and the quantity are exactly aligned per column.If I read the file like this:
[code]...
Then the semicolon is not presented in the listbox and I don't have any alignment per column. As the names of the woods are not equally long the prices and the quantity are not aligned directly below each other...
My questions are:
1) How to add the semicolon in the listbox as seperator of the columns
2) How to align the 4 columns in the listbox (as I have an array Item(3) )
Later on I need to be able to change the quantity (last column) from 0 to > 0 (that's why I have to use an array)
when the user clicks on the add button another form launches, which enables the user to add student info such as name, address, course, start date and end date, this information is then written to class when the ok button on that form is clicked, and then displays the data on the initial form in data grid. the user can add multiple entries and they are all displayed on the intial form and a the data grid is populatedwhen any of the rows in the displayed grid is selected, and the update button is clicked then the same form launches as the previous one and but this time its in the update mode and pre populates the form with the inital values.
View 3 RepliesI am building a business intelligence application for my organization. I have a form in which I would like to display existing excel spreadsheets. I have searched high and low for a control that would allow me to display a spreadsheet. Basically what I need is a viewer control that I can user to call the individual soreadsheets and display them in the form.I do not want to open excel outside of the application, but instead display the spreadsheet in the form as part of the application.
View 3 RepliesI have written a program that will export data from access data to Excel by using XML programmatically, But I seem to be having problem when I tried to open in excel.
View 2 RepliesIn visual basic code works as below MyWorksheet.Range("A1:D1").Formula = "A1B2"
In excel it shows in
A1 as A1B2
B1 as A1B2
C1 as A1B2
D1 as A1B2
what i want do
A1 as A1B2
B1 as A1B3
C1 as A2B4
D1 as A2B5
I have to write an application in Visual Basic.Net that will open an excel file, run through the contents an export a test file for processing.
The application works great for me (Windows 7) but when transferred to a WinXP PC gives the following error: HResult 0X800A03EC
I can replicate this error by making the Excel Application visible so it seems like it is an issue where it can't access the file because it is open. Error occurrs when trying open the workbook.
Original Code
Dim excel As Excel.Application
Dim wb As Excel.Workbook
[Code].....
Im trying to add an export import method in visual basic. Export from Access database to Excel Worksheet or .csv. And Import From Excel worksheet or .csv to Access database
View 3 Replies[code]....
View 12 Repliesi would like to know how to automaticaly save a given chart from an excel 2007 file into a given folder with a given name ^^i have already got the vb sending the data i want to the excel, and with macros within excel to make the line chart in the excel file..
View 1 RepliesI'm using VB Express 2008 and I would like to open an excel file and save it with different name file. For example, I would like to open a file in
C: est.xls
And then I want to save them with different file name such as
C: ry.xls
I have created an excel 2003 file using visual basic 2010 express edition with access as backend. The excel is created using a select into query. I would need help to protect this excel file once it generated using visual basic 2010 so that the users cannot edit the same.
View 1 RepliesI am trying to read off some cells from an Excel File. I can't figure it out. Here is my code:
Public
Class TOC
Dim ExcelObj As New Microsoft.Office.Interop.Excel.Application
[Code]....
After making WorkSheetObj I dont know what to do.. I am trying to dynamically change the Texts of Four buttons. The text values are to be to read off of Excel cells.
The idea is that I have certain values stored in textboxes/listboxes and thus can I store the information in a spread sheet. And if I change the value in the spreadsheet can it also change the value in the application? I had one idea which was to make both store data in a txt file and read from that, but I'm not quite sure how to do that either.
View 1 RepliesHow can i save my data into a pdf Using visual basic?
View 1 RepliesHow do you extract source code from a VB.NET .EXE file?
View 3 RepliesMy .NET application gets this XML response from the W3C's public validation server:
<?xml version="1.0" encoding="UTF-8" ?>
<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
<env:Body>
[Code]....
How can I fix the broken code above? Or: Am I way off track with this?
how to link data base in visual basic
View 5 RepliesI would like to be able to download data from a specific website.
It's a gaming site with gamer stats posted on it and things like that. I would like to try and retrieve the players from that match as strings
[URL]
The names below is the data I wish to retrieve
I was wondering what is the easiest way to save and load data through different forms in vb. I just want to save 3 textbox.text that a user saves and be able to load it o
View 16 RepliesWhether I am using VB 2008 Express or VS 2010 Beta 1 Visual Basic, I get the same error: "Debugging information for 'EXCEL.EXE" cannot be found or does not match. Cannot find or open the PDB file" I have filled in the Debug Tab information: Start external program: C:Program FilesMicrosoft OfficeOffice12Excel.exe
[Code]....
how can i get data from mysql table and show it in listbox in visual basic 2008
mysql table
id
filename varchar 255
filetime timestamp
and it is windows application
I have a Data Grid View pulling in rows of data from an Access Database. I would like to code it so that when a user double clicks on a row, a window opens with that particular row being opened.
In addition, I would like to code a button so that it does the same, that is open a window with the selected row data.
How can I get the selected row ID or other data in VB?
EDIT: Forgot to mention this is a DataGridView.
I try to find the example for reading data from USB Joystick using VB2010 but I couldn't. .
I found some but all were VB6.0.
Do I need to install DirectX or which component should I use. I can read data from mouse and keyboard.
I have some data in CSV format which needs to be updated from Visual Basic code.
While updating the record, I am getting the error
[Microsoft][ODBC Text Driver] Updating data in a linked table is not supported by this ISAM.
I have created a DSN named as "dsncsv".
Here is my code: Dim ExcelCon As New ADODB.Connection Dim ExcelRs As New ADODB.Recordset
[Code]...
I was wondering how to get a certain data from a MS database and display in a label. Example(Database entries)
[Code]....
The name will be displayed in the label depending on the year and number typed in two text boxes. So if typed 2009 and 1001, the label should display name2. I don't have any background on SQL. The only thing I did for now is that I added the database in the data sources and added a TableAdapter.
