I have designed a application in MS Excel 2008 on Windows XP using Visual Basic Application (VBA).Each and every thing is going fine on my side.My client is using MAC OS and MS Office for MAC. When i deployed my application to Client end one serious problem comes arise.
The problem is that when my client is opening this project he is getting it into the Design Mode.
[Code]...
Can VB.NET be used to develop games in Microsoft Excel? Have seen interesting games such as Batman that run in Excel and would like to know what programming language is used for that.
View 5 RepliesI am working on Excel programming . Can you suggest the best publications for the beginner in Excel Programming.
Tasks Ahead:
To create a comboBox dynamically in Excel Worksheet Write events for comboBox_ change/click Dynamically changing the items in the combo Box
am developing an application automatingExcel 2011 from Visual Studio2010 with Visualasicthe problemis that I can call other subroutines.I developed the following subroutine to addformatting to the selected ce
View 3 RepliesCan anyone point me in the right direction for a good book or web site for Word and Excel Programming for VB. I'm not talking about VBA, I need to "work" with them from within my program not from within word or excel. I need to upgrade programs that were looking at Office 2000 and we're going to 07 or 10 not sure yet but figured I could at least get a bit of a jump on things.
View 2 RepliesI have recently taken a liking to programming, and have programmed a few games in C#,my friend has asked me to program an application for him to use in his shop. But I have no idea of what language is best suitable?
View 8 RepliesI am trying to access the parallel port and want to on off an LED connected to the parallel port. i have read from different tutorials and write the code. but it is not working.
vb.net
Option Strict Off
Option Explicit On
Module InpOut32_Declarations
[Code].....
im programming this group of hexadecimals this group of hexadecimals are connected to a serial port(drag out from vs 2008 tool bar) so dat the serial port can trigger on or off
however i only need to change a certain portion of the hexadecimal...
how to do socket programming in VB. I'm using VB.NET 2008 and i'm a novice but with a reasonable understanding of programming so I want to learn by examples and understanding it in a novice/intermediate point of view. Essentially, I want to create a simple TCP or UDP client that can connect to an IP and port and retrieve the stream for parsing of content.
View 5 RepliesI am not sure if this is the right area but I am new to Visual Basic and what I am trying to accomplish is creating a combobox in visual basic 2008. I have made the box and put in the list i needed but programming it to what I am needing is not working right. What I am looking for is the proper code when selecting an item in the dropdown and clicking next it will run an application (most are going to be .bat files). Like if I select Admin Batch in the list and hit next it will run admin.bat or if I select Printer Install then click next it will run printerinstall.bat.
View 9 Repliesi'm currently using my computer as host and client.. i ran the program and the console application for the server started.. but how will i be able to run the form application for the client? can VS run 2 programs at the same time?
View 6 RepliesI need to write an program with two players rolling a pair of dice and the highest tally wins with an Game class having with two member variables of the type PairOfDice. I can not get it to work.
[Code]...
States =
Dim decNeb As Decimal = .0684D
Dim decKan As Decimal = .0645D
[code].....
I have been working on this all weekend and can't figure out what I am doing wrong. The objective is to collect 3 numbers from the user then display to them the numbers they entered, the lowest number entered, the highest number entered, the total, and the average. Can someone review this and tell me what I am not getting?
[Code]
I have encountered on my project that was due in 2 days ago. I have created a form that will not display correctly. Here is the assignment and what I need to accomplish. Major issue the display bill box.
[Code]...
Is it possible to create a programming language using vb.net?
View 4 RepliesI am trying to retrieve the data from EXCEL 2003 spreadsheet from row 8 onwards because from Row 1 to Row 7 the row is merged columns from A1 to K1, A2 to K2, A3 to K3, A4 to K4, A5 to K5, A6 to K6, A7 to K7.
View 28 RepliesI have to provide an Excel file as an output. I have to color some of lines and make them bold.The input is based on a dynamic list (in memory) and it also could be based on CSV file that I'm already provide today (based on the same dynamic list).I'm wondering what would be the most efficient way (in terms of performance) in order to provide the colored Excel output?Should I export directly from dynamic list into Excel - or - Should I export from CSV into Excel ?
View 7 RepliesI am using Visual Basic 2008 and currently having a coding problems. I have coded a simple game in which I have energy that I can upgrade by 1 point on each click of a button. And so, when i start my program, it always loops this same coding without the need of another click on the button. It keeps looping until it gets to 999 then it stops sending the messagebox and lets me continue using my program. This is an (.exe) execution file programming.
Coding :
Private
Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[CODE]...
I am trying to read excel data (Excel 2007 SP1, on Windows XP SP3) with visual basic .net 2008 (VB 9.0 SP1). I have tried several attempts and whatever I do I am getting the following error message: System.Runtime.InteropServices.COMException was unhandled ErrorCode=-2147319784 Message="Altes Format oder ungültige Typbibliothek. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))" Source="Microsoft.Office.Interop.Excel" Message="Altes Format oder ungültige Typbibliothek." Translated: Old format or unknown type libraryI have added the reference "Microsoft Excel 12.0 Object Library" to my project. I am assuming that I might have to add a different or an additional reference, but I do not have any clue which one to use. List of things I have already done:- Searched other forums- Altered the language settings- Tried it on an other Computer (Win XP SP3, Excel 2007, Visual Basic 2008 Express)- Ran the diagnostics tool in Excel - Updated all updates etc...- Reinstalled Visual BasicI really do not have any clue why it should not work?
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
Dim xlsApp As excel.Application
[code]....
I am uploading an excel file to my app and want to read it. Do I need to have excel loaded to read this?I am getting an error of Object reference not set to an instance of an object.
Public Function GetExcelData(ByVal ExcelFilePath As String) As DataTable
Try
Dim OledbConnectionString As String = String.Empty
[code]....
[URL]..a good way to create Excel files without using Ms Excel,but this is C# source code,I used [URL]..to convert from C# to VB.NET,but after conversion There are some strange errors :
Error21Too many characters in character literalc:BBBXLSExportDemoXLSExportDemoExcelDocument.vb1625XLSExportDemo
Error22Empty character literalc:BBBXLSExportDemoXLSExportDemoExcelDocument.vb1633XLSExportDemo
Build calculator using visual basic 2008
View 1 RepliesI realize this is a broad question, but how do I recieve / send packets. I know what packets I need to send and what Im going to recieve, but I dont know how to send / recieve them.
View 8 RepliesThe Calendar control (the Month Calendar) control in VB 2008. I am creating an attendance timesheet and I want the Calendar to color each date differently like e.g An employee Paul is selected from a list.
On the calendar I select the month. (The dates are not supposed to be selectable). Then lets say it is June. He is late on the 1st and the Second, so those days are supposed to be colored red (the whole block). Let's also say he is absent on the fourth and so I want that date to be coloured black. How do I do this? I tried finding a query and my friend told me that this functionality is not available in the current control and that I was best off making my own control (???).
I have tried selecting specific dates and bolding them (there is a function that allows this) but I am stumped trying to find two different ways to differentiate colours. Second:- How do I link a calendar with an Access Database?
I'm coming to the conclusion that the things I want to do in a database are better done if I run a conversion code from Excel to Access, do mighty things in Access, then have the option of converting back to Excel to distribute elsewhere. I'm already familiar with using Access and the code I keep finding in threads almost always refers to .mdb files. Below is a conversion that does not seem to work (button2). I'm trying to do this through ADO with OleDb connections. If I can convert to Access much will make sense.
Public Class Form1
Private Adapter As New OleDb.OleDbDataAdapter
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.Close()
[CODE]....................
I am facing problem in asynchronous socket communication.
1)I wanted to perform connect(from client to server) operation on enter button and send the data whatever client want to send and disconnect from server. And again client should get connect to server whenever client wanted to send data. this is the mechanism.
i.e how to reuse the socket.
2)Again Server should able to send the data to client.
Basically i am creating a Hangman program using VB 2008 Express edition and need some help.I would like some help on when a user is entering a letter for the word how can i make it so for example if the target word is "MAX" and they enter "M" i would like the lblstatus to update as "M--" obviously i would want it to be able to do it with all 3 letters.
View 2 RepliesIam developing a Windows application using Visual Basic 2008 with a SQL Server database. Throughout the program I give the user as many options as possible and have no problem with either the database or the windows forms. The program does not initially require a Login and I want toprovide the User with the opportunity to add a Login to the system. The default Login form is perfectly satisfactory.
The problem is that I can't figure out how to program the change sothat the Login from isopens the program rather then th form designated as the StartUp form. this forum I am able to prgrammatically change the form but I can't figure out how to make the requirement a permanent factor. I tried using a Constant, but if the User wants to change, you can't change the constant. Its an apparantly simple yes/no situation but if I set a varable to yes and then change it to no the next time the program runs, the change will be lost.
I avidly create games in VB.net. Being a hobby programmer I give my games away for free. Since I'm a hobbiest without formal training I do try and educate myself on proper programming principles and follow them when programming such as OOP. There are however some things I have obviously missed being self-taught that perhaps I would know if I were formally educated. Once such issue that has really been my bane is how different classes (from now on referred to as objects) 'know' about each other WITHOUT programming specific interaction.
Okay imagine this, you have a space game and the following objects
[CODE]...............
Now each one of these objects has a Health, X,Y and Z private members and properties that are all inherited from clsSpaceEntity for argument sake. Now one way of programming collision between them would be to code out the following logic in the main game loop
[CODE].........................
Now this might seam okay if your talking about the simple example above but some of my games have tens or even HUNDREDS of objects that interact in this basic way. Is there a way in OOP to do the following... for each thing that inherits from clsSpaceEntity check against every other object that inherits this type (except itself) and if they collide then reduce health next? This sort of ability for a type of objects/class or whatever to be 'aware' of another and how they are the same/different and interact would save me tonnes and tonnes and TONNES of coding.