Good Site Or Book For Word And Excel Programming For VB
Aug 5, 2010
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
ADVERTISEMENT
Apr 21, 2010
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.
View 1 Replies
Mar 9, 2010
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 Replies
Dec 29, 2011
Can 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 Replies
Feb 28, 2011
In 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?
View 3 Replies
Mar 9, 2011
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 Replies
Nov 3, 2009
I 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 Replies
Jan 17, 2012
I 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 Replies
Jan 13, 2011
I'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 Replies
May 20, 2009
I'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 Replies
Feb 12, 2010
Can i get any best tutorial/Book/site to learn ADO.Net
View 1 Replies
May 4, 2010
Good site that covers all aspects of arrays?
View 1 Replies
Jul 29, 2009
I 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 Replies
Jul 29, 2009
I 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).
View 4 Replies
Apr 28, 2009
I need code to save the opened excel book (save as) and close it.
View 1 Replies
Apr 28, 2009
I 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
View 5 Replies
Jun 14, 2009
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]....
View 1 Replies
Oct 28, 2009
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]....
View 2 Replies
Feb 26, 2011
Does anyone know of any good tutorials for creating Excel Addins?
View 1 Replies
Dec 12, 2009
I 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 Replies
Jun 10, 2011
I find error after publishing vb.net page which writes in word document
View 5 Replies
Apr 4, 2010
I 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
View 8 Replies
Jun 9, 2009
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].....
View 1 Replies
Nov 27, 2011
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 Replies
Apr 17, 2010
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]...
View 2 Replies
Apr 13, 2010
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
View 2 Replies
Dec 21, 2011
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 Replies
Mar 26, 2010
I 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 Replies
Feb 9, 2010
Ive 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]...
View 2 Replies
Oct 13, 2010
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