Are there any books written with the focus on how to control MS Office (Excel, Word, Powerpoint) through VB.net applications? I only have checked the book Professional Excel Development that shows a little bit on automating Excel from VB.net. I would need a much more comprehensive book (or links to web learning pages) on the issue.
View 6 RepliesI'm just curious as to how some software programs that I see out there have the ability to extract links & text from thousands of web pages at an extremely high and fast rate. Has anyone here, ever created a link or text extracting program the has the ability to parse many webpages and return data into a textbox? I know how to extract links via the webbrowser control, but it doesn't seem to parse/extract data at a very high & fast rate like many email, link & text extracting programs that I see out there.
[Code]...
I have a program in VB.NET 2005. At some point I have to open an Access2003-Application for getting data in it. I do that by pretending my program is a human user and let it do all the work in Access as a human user would do. Filling Fields, pressing buttons etc. I use the Primary Interop Assemblies for that. So far so good. That code is in use for over half a year now. In the last week I got Office 2007 installed on my machine. Of course I tested the installed version of my program if everthing still works. Every test was succesfull. But if I do the same tests in Visual Studio it always crashes.
All I get is this Errormessage: {"Das COM-Objekt des Typs "Microsoft.Office.Interop.Access.FormClass" kann nicht in den Schnittstellentyp "Microsoft.Office.Interop.Access._Form3" umgewandelt werden. Dieser Vorgang konnte nicht durchgefhrt werden, da der QueryInterface-Aufruf an die COM-Komponente fr die Schnittstelle mit der IID "{66B22FB4-F70E-4F03-A00A-F76E9ADBBF10}" aufgrund des folgenden Fehlers nicht durchgefhrt werden konnte: Schnittstelle nicht untersttzt (Ausnahme von HRESULT: 0x80004002 (E_NOINTERFACE))."}
For all who can't read german:
"Microsoft.Office.Interop.Access.FormClass" can't be converted in to "Microsoft.Office.Interop.Access._Form3" ... Interface is not supported.
Code I use:
Dim access As Microsoft.Office.Interop.Access.Application = Nothing
.
.
.
access = New Microsoft.Office.Interop.Access.Application()
[CODE]...
The Error occurs when I try to access any property of "access.Forms("frmTest")"
my webbrowser navigates to a webpage. I need to store all the links into a collection, I did find the code to do the job (on this forum) and it works, but there is a problem: there are more links on the page than those the code reads, like when i right click on a picture and choose "copy shortcut" I get a link that is not showing when I display the "view source" for the entire page. I can't figure out how to do it.
View 3 RepliesI'm starting a new project to handle info from some text files, a kind of sorting module so I'd like to give it a try using LINQ but looking for a book I realized that there are more c# books than vb, so I wonder if c# have better support or if it is more suitable than vb.
You think there is some advance on use c# or vb.
I have an Access 2007 database connected to SQL Server 2005. I want to use VB to create an application that will retrieve and manipulate data in our SQL database. I'm familiar with VB and I'm familiar with Access. What I don't know is how to get started creating forms in VB that's accessible through Access. Are there any books out there that will help me get started?
View 3 RepliesWhat would you recommend as the "best" VB.NET and C# books for learning Design Patterns?eferably books that actually give examples of when to use the patterns. I need torecommend some books to a group of C# and VB.NET developers.
View 19 Replieswhile creating Excel files in vb.net, all is fine, except when I want to close my PC and there are many popups to save or delete "bookx.xls". How do I prevent these blank books from being made??
View 2 RepliesI never touched the crystal reports topic before but i hae been through certain articles and found that i't not hard as it sounds. however, i need names of some good books on this topic..
View 2 RepliesI am looking to write my own media library and was wondering are there any free .Net APIs out there to identify a product based on a given barcode? As a secondary point are there .Net APIs to return cover art for books, CD, games etc based on a barcode.
View 3 RepliesI'm looking for some good quality OO books, if any exist for VB .Net
View 10 Repliesim tring to switch to vb.net i guess thats the only way im going to learn how to make phone apps.when i bought vb6 i thought ms would send all the books involved , maybe in pdf formate.
View 2 RepliesIt has been nearly 4 years since I have started developing with .NET - mostly with ASP.NET and SQL Server. I rarely got any time to work with Desktop application but now I want to get lower level knowledge of windows application - I mean hows window application works (Hows form is drawn, what kind of lower level objects are being used, how user control detect keystroke and up to what hierarchical level etc.)
View 3 RepliesWe have currently upgraded our development machines to Windows 7 and Office 2007. We have a vb 2008 app that references 2003 Office components to use for mail-merging to word.We loaded up our app in the vb environment today and were instantly greeted with missing components/functions which are related to the 2003 Office components. We can update these to use the Office 2007 components/functions instead, however we are unsure whether after doing this our vb app will work with machines only with Office 2003 on. can machines with Office 2003 on work with our vb app that references Office 2007 components?
View 5 Repliesi was wondering if someone could give me the final explanation on what i might be doing wrong here.I spent a lot of time reading around the net and the forum about how to add Threading capabilities to a VB project.
Nos, i've got .NET 4 installed, and i've added the system.tsr and mscorlib.dll files as reference in, say, Excel 2007 (see screenshot).However, when i try to make a thread with anything as basic as "Dim Thread1 As System.Threading.Thread", i get a user-defined type not found error.Indeed, when i use the object browser to see what's in the System file, theres nothing remotely linked to any Threading, and in the mscorlib file, nothing under "Threading" either, just a few Thread related functions, but nothing defining a data type
I've developed shared addin for Microsoft Word. I distribute this addin with my application and using Inno setup for installation. The Inno setup installs my application and then runs "myAddin.msi" file in order to install addin.
how to uninstall this addin programatically?
Right now, in order to uninstall addin, the user has to to it manually through control panel.
I have tried a lot to search a book which has good discussion about sending SMS through vb2010 application.I have tried in Google,Bing, Google Books etc. but couldn't find any book which can teach me how to sent sms through WEB API..
View 8 RepliesI would really love to work on some .NET programming and SQL(what my job will consist of). You can never learn too much programming .I've finished the VB book I had in class last semester and would like some either websites or book recommendations. I would like the website/book to have a problem and have me make the program however I see fit. Also, Are there books/websites out there that incoprorate databases with .NET programming? I'm having a hard time finding that.
View 1 Repliesit seems that every Excel workbook I create in Vb, Excel automatically creates a ghost book with the name Bookn.xls where the n is incremental. After a lot of processing, I could have 20+ blank books open and running in taskmanager!
View 7 RepliesI'm creating a rather large and complex application and was wondering if any of you had any recommendations for good books on application and project architecture. Multi-user - database - heavy interaction with windows api for shell extensions.Not the standard maintenance or reporting app I usually write!
View 2 Replieshow do i use the webbrowser to display the word or excel docs. just like the pdf viewer... i tried the webrowser1.navigate but it didnot work, if it does its opening a new window, im using office 2010..
View 4 RepliesHow do I use the webbrowser to display the word or excel docs. just like the pdf viewer. I tried the webrowser1.navigate but it didnot work, if it does its opening a new window, I am using office 2010.
View 1 RepliesI've made Add-in for Word 2007 in VS2005.It worked well with Word 2007 and now it works well with Word 2010 32 bit.However it doesn't work with Word 2010 64 bit. The installation is successful, but the ribbon button doesn't show up.
Do you have any experience with add-ins for Office 64 bit?
i am new to vb.net programming i am trying to access excel worksheet pre defined with name Books.xlsx through vb.net i have taken a form with one command button i wrote below code in that:Imports Microsoft.Office.Interop Imports System.Runtime.InteropServices
[Code]...
I can download the vb.net 10 Language Specification from Microsoft here 600+ Pages is a lot to print out. So I want to know is there a Dead Tree version (A book)? If so, where can it purchased?
View 2 RepliesI am building a program that calculates the number of books by points.Ex: 1-3 books read are worth 10 points, 4-6 are worth 15 and > 6 are worth 20. The issue I'm having is getting it to calculate the the first 3 books, the 2nd 3 books and then the > 6.Ex: User inputs 8 books read. It should display 115 in the label.
1. I'm using an If statement (should I be)
2. Could I use a decimal for the > 6?
Ex: intTotalNumberOfBooks = (intTotalNumberOfBooks * intFirst3Books) *#D
I know this is something simple and it's out of VB 101, but it is my very first programming class and my professor uses a copy paste method during class.
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 RepliesThe user can select from either print or audio books and add to the shopping cart. The list box shows all items in the shopping cart. There is a 6%. sales tax on the total cost of the items in the shopping cart and a 2 dollars shipping charge per item in the shopping cart. to remove an item from the shopping cart, the user selects it in the list box and clicks the remove button. the subtotal, tax, shipping, an total fields should be adjusted accordingly.
To add one of the items in the list to the shopping cart, the user selects it and clicks the add book to cart button. to cancel the operation, the user clicks the cancel button. I am using a standard module to declare global variables. My file is attach I have the problem that everytime I add a new item, it will just add 2 and then I add another item and it add 2 it does not show the subtotal or the tax and shipping and the real total....
Module PriceCalcModule
'constants for Print
Public Const g_decDID_YOU_KNOW As Decimal = 11.95
Public Const g_decHISTORY_SCOTLAND As Decimal = 14.5
Public Const g_decLEARN_CALC As Decimal = 29.95
Public Const g_decFEEL_STRESS As Decimal = 18.5
[Code] .....
I want to create a lookup program for library books using VB6 or VB.net.
I have created a Form1.VB with two listboxes :- Listbox1 Listbox2.
Im using an Access Database with a Library Category Table
Field1: Category
Library Title Table
Field1: Category
Field2: Title
Field3: Author
Field4: Publisher
Using the Data Adapter ConfigurationWizard Ive created
OleDBDataAdapter1
OleDBConnection1
And from the Library Category table Ive created Dataset1 attached to Listbox1
OleDBDataAdapter2
And from the Library Title table Ive created Dataset2 attached to Listbox2.
Both Datasets fill using the Preview Data function. I then load Variable CategoryString with Listbox1.text,
and I would like to know how to search Dataset2 and retrieve all titles linked to that category and display Title, Author, Publisher in listbox2.
I am a self taught "developer".I use the term loosely because I only know enough to make myself dangerous. I have no theory background, and I only pick up things to get this little tool to work or make that control do what I want.
That said, I am looking for some reading material that explains some of the theory behind application development especially from a business standpoint. Really I need to understand what all of these terms that float around really talk about. Business Logic Layer, UI abstraction level and all that. Anyone got a reading list that they feel helped them understand this stuff? I know how to code stuff up so that it works. It is not pretty mostly because I don't know the elegant way of doing it, and it is not planned out very well (I also don't know how to plan an application).