I have a couple of Excel macros that are working exactly as I want, and I would like to load them on other computers that may have different versions of excel. I have VB 2008 Express, and I was hoping I could use this to create the add-ins, but I am unable to find the Add-In wizard. Am I overlooking it, or do I need some other version of VB?
View 3 RepliesI am working on a VB2008 Express application that makes used of the office interop access. The exact code is:
[Code]...
I have searched the MS website and confused to say the least :blink:
If not I'm currently using Office 2003
Office 2007 Ribbon in VB Express 2008?
View 8 RepliesI added the reference and the "Imports" line, and I get the folowing error on the line
Code:
Dim oApp As New Excel.Application
Dim oWB As Excel.Workbook = oApp.Workbooks.Add()
Dim oWS As Excel.Worksheet = CType(oWB.Worksheets(1), Excel.Worksheet)
COMException was unhandled
Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
I have previously created a DLL in VB6 that I then used in a Microstation VBA program. But now cannot create a DLL with VB 2008 Express that works. I am trying to create a simple test DLL. The DLL appears in the Release directory of both the Bin and Obj directories but when trying to register it I get the following message "Can't find DLL entry point in TestRun.dll". Is it possible to create a working DLL with VB Express or do I have to "upgrade" to another "version" of VB.
View 14 RepliesOk, what I would like to be able to do seems simple enough. I would like to be able to create an Excel document with a series of columns that contain data to import into Visual Basic 2008
[Code]...
I am trying to create a DLL file in VB.NET 2008 Express which will can be called from a VBScript file. I have set up a Class Library solution but when i try to register it I get the following error.
"The module ... was loaded buy the entry-point DllRegisterServer was not found."
how to create a new mdf file in express 2008?before, I used some sample projects which have the mdf file, so I can use sql express on local machine. now, for a new project, I want to create a brand new mdf file, but can not figure out how to do it.
View 12 RepliesI am trying to do a home project and after many hours of failing to complete what seems to be a simple process I have decided to ask for some help. None of the examples I have found on over 20 websites is complete or works as the author suggests. (Im sure because of version differences)
I want to make a Visual Basic Program that, by means of clicking on a radio button and then clicking on a button named "create" will add a blank table to my db named by the string variable connected to a listbox where this name can be first entered before clicking on button1. Can someone help guide me in the right direction? The table needs to have three columns; Col1, Col2, Col3 -my database is named "Database.sdf"
Form/Interface info radiobutton1 'an option that if selected = true in the button1 click event will process the data that creates the table. textbox1 'table name input button1 to create table 'to run the process combobox1 'shows available tables that exist in the db button2 'click event shows the combobox (table) in the datagridview window button3 to delete 'to delete the selected table button4 to reset 'to clear radio button choice,textbox1, and combobox1 datagridview1 'to veiw the selected table Note: if also possible I would like a datagridview of the new table on the same form after it has been created.I am using Visual Basic 2008 Express, It is a microsoft SQL Server Compatct 3.5 Database
I am working on my new project and I need to create a table for each user dynamically. In which the user will provide the Table name in the textbox and on pressing Create button a new table gets created in the same MS access database file with the provided name.[code]...
View 17 RepliesCreate a paint application in VB Express 2008?
View 16 Replieshow can i tarnslate this code blokcs ,from vb6.0 to vb 2008 express successful work how can i do this in vb 2008 express
If Dir(App.Path & "MUHASEBECIM.mdb") = "" Then
' muhasebem is database name
Dim MUHASEBEM As Database
' tables define
Dim GENELAYARLAR As New TableDef
[code].....
First off...I am as green as it gets with VB. I have created an app that will load an image file(yourimage.jpg), preview it, strip the extension (yourimage), upload to server via FTP as (yourimage.jpg)and send an email with the link to it ( url/yourimage.html) . What I really need now is to be able to enter the code in VB to actually create the HTML page with the name as the link.The HTML page needs to load the image and have a form below it. I have a active form already online that uses e-forms to send responses back to me.
View 4 Replieswhen i try to create a new project in visual, appears (the language is spanish)"no se puede abrir 'the path of the file .vbproj' su tipo de proyecto (.vbproj) no es compatible con esta version de la aplicacion. Para abrirlo use una nueva version de la aplicacion"
this proyects was build in the same visual basic 2008 express edition.
We have currently upgraded our development machines to Windows 7 and Office 2007. We have a vb 2008 app that references 2003 Office components to use for mail-merging to word.We loaded up our app in the vb environment today and were instantly greeted with missing components/functions which are related to the 2003 Office components. We can update these to use the Office 2007 components/functions instead, however we are unsure whether after doing this our vb app will work with machines only with Office 2003 on. can machines with Office 2003 on work with our vb app that references Office 2007 components?
View 5 RepliesIs it possible to create a mobile application with VB.net 2008 express edition. I've done some research and some places have said that you need the professional edition.
View 1 RepliesIs there any way of creating a Pivot taboe in the VB 2008 Express Datagridview?
View 3 RepliesWhen I used to play wiith VB 5.0 I was able to create an array of comand buttons on the form. This allowed me to have one routine that knew which of many buttonshad been clicked and I could then take specific action based on which button was clicked. I can't see how to do this in VBE 8. Is this possible?
View 11 RepliesI need to create in my application various forms and lists containing formated text and print them out without losing formating (they can be many pages long).What is the best way to go round this (as Express Edition does not contain Crystal Reports).So far I figured to use RichTexBox for formating text, then print it by PrintForm control from Power Pack 3.
View 5 RepliesMy question is : How to create pppoe connection after clicking button invisual basic 2008 express. I have ready form with User and Pass input fields. I want to create PPPoE Connection, place shortcut on desktop and copy user and pass from fields to pppoe connection after clicking button in form.
View 4 RepliesI have created a picturebox in a form that I want to click on and then it would send me to a excel file that I already have created. I don't know if it is even possible. Do I need to use a button instead?, or am I just way off all together.
View 2 RepliesHow do you create custom chrome for a windows form in vb.net using Visual Basic 2008 express? I want to basically scrap what they give and start fresh.
View 1 RepliesI want to create a table (called "Customers") in a Microsoft Access database and then insert/delete records into the table and update the table. The table shall have 3 columns:
ID
Customer Name
Customer Address
I know i need to make the "ID" column as an autonumber and a primary key, as i need to insert and delete records and update the table. I am using the Visual basic 2008 Express edition and quite familar with the OledBcommand.
I've just downloaded SQL server express and have created a database in there. Now back in my VB.NET application from Visual Studio how do i find/connect to it?
View 16 Repliesi am creating a quiz which would be 20 questions for software design students and may use alot of code.my first problem is the score for the test, i know a friend of mine can add up the score but he cant move onto the next thread until you have got the question correct which is sort of cheating, i want to know how you create a variable and make that variable stay in all the forms and add up the score of correct and incorrect answers and come up with a final score for the user in the end.
View 8 Replieshow I can implement my calendar with VB .net express 2008 and MSSQL 2008 Express. How do I get it to work with datasets, binding source etc.If I go to Properties>settings my connection string is:
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CalendarDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True
and I have a table with fields:-
CalendarID
Subject
Location
Purpose
[code]....
I can Add the event to the calendar I have the necessary items on my form linked to my table and I can save them to my table:
Me.Validate()
Me.CalendarTableBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.CalendarDatabaseDataSet)
But I cant keep the event displayed on my calendar when I close it and open it again.
I'm just using the default SQL Server Express in my vb 2008 express edition as my database server for my database operation. When I tried to update the records on my table I got a runtime error which indicates the error on this line 'myCommand.ExecuteNonQuery()'and it highlights a yellow background on it. The runtime error says "SqlException was unhandled: An expression of non-boolean type specified in a context where a condition is expected, near 'Number'. ".
Imports System.Data.SqlClient
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim myConnection As New SqlConnection
Dim myCommand As New SqlCommand
[code]....
I tried to start using VB 2010 Express with a program I originally developed with VB 2005 Express that I moved to VB 2008 Express successfully a couple years ago. It uses a database file (*.mdf) that is on the computer ( not out on a server). When attempt to run the program in debug mode, I get the following error "An attempt to attach an auto-named database for file C:Documents and SettingsTomMy DocumentsQuizzing StuffQuestion Database 2010QuizQuest ionGameQuizQuestionGameinReleaseQuizQuestionDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I first made a copy of the entire project folder that was working in VB 2008 Express and gave it a different name. In VB2010 I opened the project in the copied folder and it said it successfully converted the project. I am able to open the Data Source inthe Designer and see the database structure as I expect. I think the project is still using SQL Server 2005 Express (because it is what is checked in the list of prerequisites on the Publish tab).
Note, I have programmed off and on for many years, but fairly new to using databases and SQL Server.
Ok basically what I need to do is the following:Read FirstExcelDoc (attached)For every row in that: Retrieve data from sql server db based on info in the Orange columns of FirstExcelDoc Let's say I retrieved data elements A, B, C, D, and E from sql server. Then I need to enter those same data elements A, B, and C in another excel spreadsheet (which has formulas etc) After inputing A, B, and C in that spreadsheet, read a couple of calculated fields and compare those results to data elements D and E retrieved originally from SQL Server DB. Finally, output the results in the Blue columns of the FirstExcelDoc spreadsheet for that row.Loop through and do the same thing for row 2 of the FirstExcelDoc and keep on until you see "END TEST" in the FirstExcelDoc.
I'm looking for a method of doing this efficiently. I have read several articles over the past few days as well as those from Mike R. but just need some direction to get started on this.To start of I'm looking for whether to read the entire FirstExcelDoc spreadsheet or just read the info for first policy number(2nd row) and process it and write out the blue column info for that row and then loop through and come back and read the second policy number (3rd row) etc... Please attach a code snippet for either way of reading the data.