I 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
I am trying to create a program that calculates the prices of different payment methods of a buffet.The program requirements are simple. The buffet start in 1/7/2011 and ends 31/8/2011. Payments methods are online, cash and coupon. coupon is only valid from 1/8/2011 to 31/8/ 2011. 1 child is free for every 2 adult that pay. There are different prices for weekends (sat and sun) and different prices for weekdays. [code]
View 3 RepliesI'm trying to pick up some simple object-oriented programming skills so I am trying my hand at beginner's problem - and I am totally stuck...I'm trying to write a program that will print to a label, the area and perimeter of your shape of choice, dependent on the Length and Width (for Rectangles and Triangles) or Radius (For Circles) you input and the shape you select.
I know how to do this easily with simple event-driven programming, but I'm trying to do this by using classes and inheritance.The idea I have is that you enter in length/Radius and/or width into text boxes (txtLen, txtWid) and then you can click a button to display the Length, Width and Perimeter or Radius and Circumference, and Area.
I'd create a Super-Class: Shapes to define my overarching parameters - all shapes have area and perimeter. Then I would create sub-classes for each shape inheriting the overarching "Shapes" class - dim'ing all of their respective extra pieces. Then the buttons would display the appropriate info when clicked.I understand this seems like a lot - but really I just need help getting my feet on the ground for this.
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 try to publish my applications, but when I burn the folder it creates on a CD and try and install it on another computer it doesn't work. Specifically I think the "Manifest" is missing.
View 2 RepliesCan 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 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]...
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 want to learn visual basic, what book or books are the best to take me from beginner to intermediate?Would it be more advantageous to go through VB 2008 or VB2010 tutorials first or should i start with a book before going through VB2008 or VB2010 tutorials?I am comfortable with Sequel (SQL) language, learned on the job and am at the advanced level of Excel/Access writing formulas functions,etc. the next logical step is to learn VB.
View 6 RepliesI am beginner in VB.net and want to learn socket programming suggest me some good articles to refer at beginner level
View 4 RepliesI just need a good nights sleep, but Im simply reading through a file (2010 data) and for selected teams, accessing the corresponding data for the previous year (2009 data), which is held on a separate file. (I painstakingly input all the 2009 data manually)
ds1.Clear()
cmd1.CommandText = "SELECT * FROM Teams WHERE Team = ?"
cmd1.Parameters.Add(NewSqlCeParameter("Team", (ds.Tables(0).Rows(x) ("Team"))))
cmd1.Prepare()
cmd1.ExecuteNonQuery()
[Code]...
Dim conn As New SqlCeConnection, in the position marked **, it makes the program fall over on the cmd.prepare statement: requires an open and available connection
Public Class Form9
Dim compactStr As String
Dim conn As New SqlCeConnection
[code].....
I do not know anything about SharePoint and we will be moving to SharePoint systems in a few months at work.
My manager told me I will be one of the developers developing systems based on SharePoint.
Is there any good video tutorials on SharePoint Development?
The program should request the person's occupation, the amount of the bill, and the percentage tip as input and pass this information to a Sub procedure to display the person and the tip. Title is gratuities, first line Person's occupation, amount of the bill:, Percentage tip: Compute Tip, and show the tip. Im not sure how to approach it properly.[code]
View 2 RepliesI need comprehensive tutorials of VB 2008 for beginner's which give additional support to my studies so that I can learn VB 2008 easily in less time.
View 2 RepliesI had this incredibly ambitious goal to make a video game and so I am teaching myself/relying on kindness and knowledge of others as I go along. So far I have learned a lot, however needless to say, this is a monstrously difficult challenge, however one that I am very passionate about completing. The idea is that I am making a trading card style game and I was hoping that I could continue to use this thread and your kindness to keep me going whenever nessecessary throughout this challenge.So, here is where I am now. (Please forgive me if i have posted too much details/not enough details. Since I am new, I am not sure what information you need to help me. This will be corrected as time goes by and I learn more)I have created a card class with two properties. name and picture with name As String, and picture as PictureBox. the constructor looks like this: [code]
My next goal(and where I am currently stuck) is making i so that when the user clicks on one of the items in the listbox, a picture of the appropriate card(saved in a pictureBox of its own on a different form, and referenced in the card via the picture element) will be placed inside the empty picture box on the deckPage.
Im using Visual Basic 2008.Okay I got all the design, and everything set up, even the hangman body parts coming on the screen and stuff. So my problem is creating the BLANKS, the underscores "_", and replacing them with a letter...
I was thinking creating Lables which i have no idea how to dynamically. Then giving each label name the letters they belong to, and everytime the user gets the rigth letter they get replaced.
I am having an issue getting my code to work. It is not showing my Look-Up Button for me to calculate the rate based on the weight and zone and it continues to constantly show that I have an error that I cannot seem to correct.
[Code]...
I have been looking for a good beginner tutorial on polymorphism, inhertance,and related terms.Something where I can start at and go through and get most of the common programming terms and techniques explained with examples
View 1 RepliesI'm beginner programmer in the amazing world named ".Net".I've a lot of questions
well, what I should learn C# or Vb.net What's the best blogs which talk about .Net technology and Open source projects Where can I find good tutorials, free books and ideas of projects how can I progress in ".Net" please, share your knowledge , your OPML of your favorite blogs or web sites about ".Net "
Student pursuing BSIT degree, employer expectations, entry level. I would like to solicit opinions from this forum as to what your professional expectations are as regards an entry level position in working in the database realm... I see many job opportunities that require a minimum of 2 or more years experience, how does one go about obtaining this experience (I have tried very hard to maintain a minimum 3.70+ GPA) but have ZERO work experience in this field... I spend non school time working in VB and SQL to try and increase my proficiency. I have considered postponing my job search until I obtain certifications from brainbench etc... Any criticism and or advise is welcomed... Again I have no experience in database other than undergrad work in class.
View 2 RepliesI am trying to create a program that the user enters the number of enrollments for 5 different campuses during two semesters. I just got started and here is what I have so far but when I run the program it is stuck in an infinite loop and will not go to the next function. I am not sure how to end the loop. Here is what I have so far:
Module Module1
Dim SIZE As Integer = 5
Dim campus() As String = {"Decatur Day", "Decatur Evening", "Huntsville Day", "Huntsville Evening", "Distance Learning"}
Dim semester() As String = {"Fall 2010 semester", "Spring 2011 semester"}
[Code] .....
I am just for learning purposes trying to develop a one player text based game.
I have a rich text box (GameWindow)
I have a text box (InputWindow)
I have a button (InputButton)
and a bunch of labels that aren't really important
I have two questions first is easy probably. How do i get InputWindow to respond to me hitting enter when text is in it?
[Code]...
But if i plan to have more that is only going to increase the size and code needed and im sure there is an easier way i just don't know how to do it.
I 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 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.
I need to access the current instance of MS Excel. To do that, I wrote the following code:
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Diagnostics
Private _ExcelApp As Excel.Application
[Code].....
The code runs nice, but it has a problem: After the user close the Excel application (click button X - note: no other instance of Excel exists), if you open the Windows's task manager, its possible to see the process Excel.exe.
If I open and close the Excel application, there is no process Excel.exe, but if I run my code with the Excel application openned, after the user close the Excel application, the process Excel.exe isn't finished.
can I use Excel APi (Interop.Excel) without installing MS Excel.
View 2 RepliesI want to encapsulate the use of Excel Interop to make it easier to use somehow in a reuseable library.So far, I have written some tests that work good altogether, except that between each test, I force Excel to quite so that it does have handle on the test file no more in order to be able to delete.Once I quit the application instance between after each of my tests, Excel seems to be no longer responding, causing Windows to display "Excel has stopped working and is looking for a solution"
message. This message lasts a few seconds, meanwhile Excel is closing, causing the hang on the file to occur and my tests to throw an exception like "Cannot access file because it is being used by another process..."
[Code]...
I am using VS .net 2003 and developing a program that calls Excel. The development computer only has Excel 2003, and the target machine only has Excel 2007. Would it be possible to install Excel 12 Object Library in the development computer without installing Excel 2007?
View 4 Replies