Can 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 Replies
I am starting off in the .NET world and wanted to know what a great beginner book would be that would explain how to use asp.net, vb and SQL.
I hear "Learning Visual Basic" is a good series but wanted to see if there were anymore out there.
I am really interested in learning VB .net, but I don't really know where to start. Could anyone recommend a good book or website to start learning.
View 15 RepliesCan anyone recommend a good VB book that will teach functions, file IO, arrays, recursion etc. A lot of the ones I have looked at are very basic I started Sam teach yourself VB 2010 in 24hrs but a lot of it didn't relate to what we do in college.
View 2 RepliesIn my applications I use objects and classes, but when reading SO topics, I have the idea I don't use real OOP principles. For example, I never use inheritance or interfaces. Therefore, I am trying to learn proper OOP (in VB.NET), but I find some concepts quite hard to understand (even after reading a lot about the subjects on SO).So I'm trying to find a book or resource with good practical real-world examples. For instance, I kind of understand examples like using an interface for both Dog and Cat classes when using a EatFood method, but I find it hard to relate it to real-world cases.Ideally these books or resources should cover explanations about:
- when and why to use inheritance or interfaces or abstract classes
- when and why to use private, public, protected, virtual etc.
- best practices in dependency injection /inversion of control
- when to use aspect oriented programming
- using of constructors
- solid principles
- singletons
- encapsulation
Perhaps it's a mix of all kinds of concepts, but I think these are all related to OOP, please correct me if I'm wrong.I would prefer a book/resource with VB.NET examples, but this might be difficult?
I'm still a noobie whe it comes to VB.NET but I am going to be specifically orking/interacting with websites such as passing variables to textboxes, clicking on buttons, etc.
View 1 RepliesI am a EE graduate from about a year and a half ago working in the semiconductor industry as a hardware/test engineer. I wan't to learn VB to do lab level data test and acquisition. I am learning this in my free time at work and home, and I would be using VB to talk with different electronic equipment through GBIP to source, measure, and record data. Anyone have any good ideas of a good book for such applications?? I know there are a ton of books and courses out there, but 99.9% of that information is not going to be needed for my industry application. I also took a few C classes in college, and I have some experience with labview so I am not a total noob to programming. So if anyone has a good book, or refferences that would be really appreciated.Also what version of VB would you recomend me learning?
View 4 RepliesI begain in 1971 learning TRS-80 Model III Basic language...later taught myself Lotus 1-2-3 and then DBase. Later, graduated to Visual Basic Stopped at VB 6.0. Now I need to move up to VB 2010...I have been programming for our company for sometime and use VB 6.0 as a front end for numerous Access DB applications.Can you recommend a good book (or books) out there that can help me with using VB 2010 as a frontend for Access?..just need the basics to be able to make connections, query the tables, return the data, update data, etc.
View 6 RepliesI'm new to VB but completly new. I've dabbled with it a bit before but mostly from copying and pasting code from online. Is there a good book that I can purchase that will show me the ropes of the basics?
View 5 RepliesI'm looking for an advanced level VB.NET book which covers LINQ and Lambda Expressions.Generally I read C# .NET books due to lack of good VB.NET books when it comes to generic .NET Framework related subjects. However Lambda and LINQ is quite different in C# and VB.NET I'm looking for an advanced level VB.NET book on this subjec
View 1 RepliesCan i get any best tutorial/Book/site to learn ADO.Net
View 1 RepliesGood site that covers all aspects of arrays?
View 1 RepliesI need to develop an application that can search through a book and list out all the pages and lines that contain a given keyword. For books that are split up in some other way, such as a bible which is split up by chapter and verse; they would be able to search for all verses that contain a certain keyword. Or alternatively, search within certain chapters and verses for a keyword. What format should I store the book into? Should it be stored into a SQL database? What format would be easiest for searching as opposed to easiest for storage?
View 7 RepliesI realize that this would mean a third-party component and I've looked at a few. Does anyone use/know of a component that they would recommend to get reliable, quality Word to PDF conversion via a VB.NET application?
Anyone know of any cheaper options that will do a good job? I tried a couple of cheaper RTF to PDF convertors, saving the Word doc as RTF via the app but the PDF they output lost formatting on Word tabs, table of contents, page numbers, etc. Not good enough.
Otherwise, I will have to tell the app users they will need to convert the Word doc to PDF themselves (unless they have Word 2007 and pdf add-in which I can probably offer as an option).
I need code to save the opened excel book (save as) and close it.
View 1 RepliesI want to save the opened excel book and close it. My code is given below but i found errors in that code .
xlBook.SaveAs (strTargetFile)
xlBook.Saved = True
xlBook.Close
I am working in VB.net 2008. I have a Window application that will be used to eliminate a lot of manual copy and paste activates from one work sheet to anther. Workbook 1 (wbMatrix)Never has the same layout twice. The destination Workbook2(wbTemplateSAS)has a defined layout that remains constant. To collect the copy ranges the user pouplates the text box on the form. Only the textbox that need popualted. There are 16 total. These textbox values are then concantianted to create the range. This process is intiated with button click.
When itinated the copy and paste works but not as expected. Cell.text range paste correctly In A9, OEC range paste correctly in P9. After that it skips the next colume as it should. Then in colume R9 the error starts the a paste of the range A10:B10 form wbMatrix is pouplated in R9:S9 Then It paste accoring to the application T9. Then in U9:X9 it paste date for wbMatrix A10:D10. It paste correctly again in Z9. it has the same error agiain till the next Range. It then paste correctly in 9AD. This should be the last paste that have values entered in the textbox to create the range. But it does not finish it paste the balnce of the cells form wbMartix on wbTempateSAS.
To sumerize above
wbMatrix Paste to wbTemplateSAS
First Row =10
Last Row = 158
[code]....
how to load data (Book) to text box when user just enter the book code?how to load data (student) to text box when user just enter the student id?how to write the code when user click the save button , the book quantity(Book) will reduce 1 and the all the data in textbox will save in database(Issue)the interface is like
[URL]
the database is show at
[URL]
the code is
Public Class frmIssue
Dim dt As New DataTable()
Dim rowIndex As Integer = 0
Dim rowIndex1 As Integer = 0
[code]....
Does anyone know of any good tutorials for creating Excel Addins?
View 1 RepliesI have been looking for a good Example of Code to Compare 2 worksheets in the Same work book I have not had much luck. The Goal when complete is to compare Sheet 1 to Sheet 2 Then the Difference Recorded on Sheet 3 as a complete row with a date Stamp in A . If it is just a change then it is color coated Orange. If total new entry that was not on the sheet then it would be green If a Row is deleted in would be Pink.
View 7 RepliesI find error after publishing vb.net page which writes in word document
View 5 RepliesI want to to find those word in array list which give the same spelling when we spell out it from Right and left site.
For example. like this word (Ababa)if we spell out this word form Right and left site it give the same spelling
I've been tryin' to develop macro, that can find table in the word and then copy it into the excel. Now it works, the only problem is, that is only the first row, that get copyed...
example (cell /w three lines in it):
Today is great day
Today is not a great day
Today, it is outrageous day
and with the code bellow, I get only Today is great day
Code:
For Each tTable In ActiveDocument.Tables
n = 1
With tTable
[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 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]...
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
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 RepliesI am not sure if this is possiable but I am looking to build an application that will login to a web site, navigate the site and download files. I would like to do this all in code and able to run multiple instances of the program to get information from many different web sites. Is something like this possiable in VB.net?
View 3 RepliesIve got an app that holds a list of site we have, At each site there are a few devices. The idea is when they click on a site all the details for the site are loaded and then a second thread sits and pings each device to see if its live. Im trying to do this in a seperate thread so if they click another site while its still pinging them it doesn't wait before it switches site. This all seems to be workling fine except if you click through the sites quickly, when you do that it will eventually come up with
Quote:
{"Collection was modified; enumeration operation might not execute."}
The error flags up on the "Next" line in "ThreadedPing"
Thread stuff
Public Sub ThreadedPing(ByVal dt As DataTable)
Try
Dim dr As DataRow
[CODE]...
When i publish my program i choose to let the application check for updates via a website and if their is one update automatically when the program starts. Is their a way were on the main user form i can make it so that the user can change the update site with out me building the program again with the new site. I want to do this becuase the site i use goes down alot so when i changed the update url no one was able to download the update for the new update server.
View 16 Replies
