Any Good Tutorials For Creating Excel Addins?
Feb 26, 2011Does anyone know of any good tutorials for creating Excel Addins?
View 1 Replies
ADVERTISEMENT
What Are Some Good Websites For .NET Tutorials?
Mar 15, 2012Does anyone have any good .NET Tutorials? What are some good websites for .NET Tutorials? Sorry if this is in the wrong section. I don't know enough about .NET to ask in the right section.
View 3 RepliesAny Good Tutorials For Screen Scrapping?
Mar 15, 2010anyone know any good tutorials for screen scrapping? what im trying to do is make an application where i enter in keywords ...
View 2 RepliesFind Good Program NET Tutorials?
Aug 20, 2009I need VB.NET tutorials and simple VB.NET examples. I am trying to implement click events like[code]...
View 3 RepliesFind Good .NET Online Tutorials For Web Development
Feb 16, 2010I'm a Coldfusion Web Developer and I'm finding that in my local area, work for CF Devs has become extremely scarce.There were a handful of companies that were Coldfusion houses a few years ago and it appears most of them have moved away from CF development.I'm looking to expand my skillset to improve my employment outlook, and it appears that many of the web development positions that are available to me now are focused around .NET web development.The last time i took a look at .NET as a web development platform was way back during 2.0; where I found it to be poorly organized and extremely unfocused. Apparently somewhere along the line I missed the boat because that's where about 90% of the web development jobs in my area are now. I've done some searching on google to see if I can find a tutorial, something that's akin to hand-holding, and have come back dissapointed.So I'm turning to the SO community to ask for links and resources that might help better explain how .NET development works in a web development capacity, and for links to these resources so I can begin boning up my knowledge and start writing practice applications.
View 6 RepliesAny Good Tutorials / Books / Blogs That Show A More In Depth Tutorial On Managing Memory
Sep 13, 2009I probably confused memory usage issues with the UI sharing same thread as the processing (as pointed out by MusiGenesis below). However regarding the Memory usage. I am still not able to find VB.net specific syntax, although people have pointed out some great .Net and C# information below (and if I were more versed in those technologies, one could adapt to make work with VB.net).The general concepts are working fine, however I am having issues where the Mem Usage on Task Manager keeps growing as the program is used to load more and more files.On Startup, before doing anything, the VB application has 27,000 K.Once the file is parsed and even after I dispose of the File handle as well as the the data increases a lot. I strip out everything in the code and it still seems that memory in Mem Usage remains captured. There is no rhyme or reason as to why the Mem Usage is growing (i.e. sometimes it can grow by 20 mb when reading a 7mb file, however other times it does not increase at all, when reading a 3mb file). Sometimes, it appers to release some memory when the parsing is complete and other times it just holds.I have looked at .Net Memory Profiler and have not really been able to make heads or tails from that.I have read a lot on internet regarding Memory Management on .Net in General about Dispose and "Nothing" and DataSets, etc, however have not really found anything regarding VB.Net specifically.My General Question is: Are there any good tutorials/books/blogs/etc that show a more in depth tutorial on managing memory in a VB.Net application (i.e. how/when to dispose/close, etc), or does anyone have some specific tips from there experience.
View 5 RepliesTutorials On Creating Card Games Using VB 2008
Jun 15, 2010I am still trying to learn as much as possible about using visual basic 2008 to create card games, more precisely, video poker games. I am really looking for either a video tutorial or a book that focuses mainly on the steps needed to begin creating the game and leads me all the way to the end completion. The game can be very basic like a jacks or better game. Does anyone know of any tutorials, videos, or books that can help me? I have a few books that provide a slot machine style game and some other good examples, but really need something more with cards.
View 1 RepliesVS 2008 Good Tutorial For Creating Custom Controls
Jul 6, 2009Can anyone point me to a good tutorial for creating custom controls. I want something that is actually understandable.I have gone through a few but nothing really any good at this point. I want to create my own contol that uses its own look and not just modifying a windows control.
View 2 RepliesInterface And Graphics :: Creating Good Perlin Noise With .Net Code?
Mar 31, 2012I've been trying to get some help for this in another thread,but it looks like it's a task that is going to need a wider audience to try and find someone who knows something about writing/creating procedural textures at the pixel level in VB.Net. The VB6 example I'm trying to convert to VB.Net is attached to this post.
[Code]...
Good Site Or Book For Word And Excel Programming For VB
Aug 5, 2010Can 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 RepliesUse The New MEF To Make Addins For An Application?
Jun 15, 2010How to use the new MEF to make Addins for an vb.net application?
View 1 RepliesCreate An Application That Supports Addins?
Jan 13, 2009I have 5 different applications that I have written for my business, they are all interfaces for a point of sale system. I TCP/IP interface handling part of the application is rock solid, problem is that occationally I will come across a small issue, such as a memory leak that I came across a few weeks ago. After I fixed it, I had to then fix said leak in 5 different projects as they all use the same interface base code.Now, if things were different, say a function that all my applications used I would just write it into a class in a dll and have all my applications use the function from that class. Problem is however, using a parent/child explanation unlike my example here where I have interface 1 - 5 as my parents using common.dll as a common child. I need to have InterfaceParent using 5 different children with different attributes.That being said, there are a few stipulations, depending on the customer I may only need to install interface 1 and 3, or 2 and 5, or 1,3 and 4.
View 2 RepliesC# - Excel Not Creating?
Mar 31, 2010i am trying to run the following code :
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
[code].....
Creating DLL And Using It In Excel
Jul 21, 2009I was having problems creating a DLL and using it in my Excel application. Here's what I've found which has worked for me immensely: [URL]
View 1 RepliesCreating A Macro In Excel Using Vb?
Feb 24, 2010I'm creating a macro in excel using vb?What the macro is doing is checking if the row and column headers are same, and if it is then I want it to save the row header (the date in this case) AND the value (a number) into an array, and this is done in a for loop and goes on.... I dont know if I should use 2-D array or a 1-D array that stores 2 values....Not sure at all !Then after the outer most FOR LOOP is done, I want to print those values stored in the array.
Here is what I have so far, this works actually however i'm using 2 seperate arrays, one to store the row header (the date) and another array to store the value. But really I want to make it simpler, shorter and use only one array that stores both of these values as we go through the for loop and at the end of the for loop, all the values from beginning which are stored can be printed out.
Here is my code :
Sub Test ()
Dim sys_arr() As String ' declaring the array to store the values
Dim sys_date_arr() As String 'declaring the array to store the dates
[code]....
This totally works but with 2 different arrays, all I want is just 1 single array (not sure if it is 2-dimensions or still stays as 1 dimension but with 2 different variables)... and then the array can store the date and variable correspondant to the date, and goes to the next row, and do same thing... So the output results should be like for eg :
2/12/2010 37
2/13/2010 41
2/14/2010 66
and so forth
Creating An Excel File?
Feb 24, 2010I have this peace of code, where I want to make an excel file:
Dim filename As String = ""
Dim sheetname As String = ""
Dim xlApp As Excel.Application
[Code]....
The problem is that this only works if the file and sheet already exists. How do I create a new Excel file?
Creating Dropdown In Excel
Jan 15, 2012Using VB.NET I created an excel sheet with list of items in dropdownlist.[code]But i can able to view the listbox upto "testing", rest of the items are not diplayed in the listbox why?Is there any limit for dropdown list items, If so how to increase the limit?
View 1 RepliesCreating Excel Chart Using .net?
Jun 5, 2011it is possible to enter values using vb.net and sending it to excel and displaying graphical representation of the values from excel to my vb form?
View 1 RepliesCreating Pivotable In Excel Via VB?
Sep 25, 2010My program exports a datatable to excel and then selects the cells in excel that have been populated with the data. I need to create a pivotable using those cells (not the datatable). The below is the code I have so far, but I cannot get the pivotcache section to work. I have looked to the VBA forums for help as well, but I don't think those are helpful since I'm creating this as VB program. Other threads I've been using as reference are:
[Code]...
Creating/Working With Excel Fro .NET?
Apr 30, 2012Creating/Working with Excel fro .NET?
View 2 RepliesCreating A Worksheet In Excel From 2008?
Aug 30, 2010I am attempting to create a worksheet in an existing excel spreadsheet from visual basic 2008 but it does not create it. My code is below.
Dim strFilename = "C: est.xls"
Dim SQL2 = "CREATE TABLE" & _
" [" & strFileName &
";].[Sheet2] ;"
[code]....
Creating An Excel Sheet From A .NET Application?
Mar 16, 2011I have a pet project of mine that I'm working on; basically, it's for scouts during FIRST FRC matches and allows them to enter data about teams into an Excel sheet. I'm having a problem creating said sheet, however. I want the program to create a new sheet, with the filename being whatever the user puts in a textbox I have. the interface takes data about teams one team at a time; when user wants to add a new team, they press "Enter Data" (which puts whatever is in the interface on Row x, then the user will be able to add new data to Row x+1 each time they press said button, etc). The main issue is that when I have the code as follows:
[Code]...
I've narrowed the problem to the "filename" and "filepath" variables. I've Googled around for answers, but the articles that I found about the error above are too vague to help me. Does anyone know why VB.NET is giving me this error? Also, how can I reuse the same Excel sheet for the entire duration that my VB.NET application is running? As in, I want to be able to add ~50 or so teams to the same Excel document (for example, all of it going into "MyRegional.xls").
Sorry if this is an obvious problem to solve or anything; I'm fairly new to programming in general, so I'm clueless as to what's going on with this. Up until this point, my program runs fine and when I comment out "Dim filename..." and "Dim filepath...", the program will run normally. If it helps, I'm running VB.NET Express 2010 in Windows 7 Home.
Creating Excel Workbook Dynamically Through .net?
Jun 5, 2011to create excel workbook dynamically where data will be input and manipulated by user. i want graph as well to be created using the data i manipulated and entered.i want as many as work sheets to be added in workbook once it is created.
View 2 RepliesCreating Multiple Excel Charts With .net?
Feb 26, 2012I'm trying to create multiple Excel charts, in one work sheet using VB.net.This is the code:
Code:
'creating the chart
Dim chartPage As Excel.Chart
Dim xlPump1Charts As Excel.ChartObjects
[code]....
Tutorials On Controls
Sep 10, 2009I am new to visual basic programming, how do i get in-depth tutorials on properties, methods etc of individual controls. For instance, i need to use the serial port control and i am great difficulties.
View 7 Replies.net - Creating A Pop-Up Calendar In A VSTO Excel Project
Apr 23, 2009I'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].....
Close Excel Instance After Creating .xls File In VB
Oct 28, 2009I am creating an excel file in my vb app. Below is the code I am using to do this. But when the application is closed, I still have an instance of Excel running in the background. How do i close it? I can do it with the xlWBook but not the xlApp.
'create empty excel file
xlApp = CType(CreateObject("Excel.Application"), Microsoft.Office.Interop.Excel.Application)
[Code].....
Coding In Excel Creating A User-form?
Mar 1, 2009I've created a User-form in excel and I need help in the coding part of it.Currently I have coded the User form, as shown below:
Option Explicit
Private Sub cmdAdd_Click()
Dim ws As Worksheet
Dim r As Integer[code].....
The section which says 'Find first free row from A21' up to'Cells(r, 4).Value = Me.txtQty2.Value' (highlighted in bold) is where I need help. I currently have 3 combo-boxes called 'cboProduct, cboProduct2 andcboproduct3' and next to each one of them I have a textbox called 'txtQty1,txtQty2 and txtQty3'. I am trying to get the first combo-box to find the first free row starting from A21 and go to cell B21 and the first textbox to go to D21. For the second combo-box to find a free row from A21 and go to B22 if B21 is used and the same applies to the textbox , if D21 is used to go D22.This also applies for the third combo-box and text box. However my coding doesn't work.
Creating And Editing Spreadsheet Without Excel Installed?
Jan 24, 2012I am looking for a way that on the form I am designing , there will be a section that displays an excel type spreadsheet that stores rows of similar information as show below.
length(mtr) width(mtr) height(mtr) cubic weight(kg) physical weight(kg)
eg. 0.15m 0.25m 0.35m 3.38kg 5kg I need the spreadsheet to allow the user to select rows and the form can have command buttons to allow then to delete selected row, etc. But I dont want to have it that the system this program eventually runs on to need to have excel actually installed on the system.
Creating Dropdown List In Excel Cell?
Feb 4, 2011I am creating an excel file and have to add a dropdown list to a cell. It looks like I need data validation, but my attempt errored on the .Add line.
With wkbSheet.Range("H" & rowCt).Validation
.Delete()
.Add(Type:=Excel.XlDVType.xlValidateWholeNumber, _
[Code]....