Q

Can I use VB.NET to connect to an Excel spreadsheet and search for a value?

How I connect to an Excel spreadsheet and search some value in it using VB.NET?

Talking to Office from .NET requires a little help. You'll need the Primary Interop Assemblies (PIA) for Office in order to easily make the calls from .NET. The PIA's are optimized to work with the managed to COM calls necessary to control Office. You can read more about them and download them by hitting the excellent article (with samples!) at MSDN library.

Get more information on VB.NET:

Learn how to access VB.NET Windows control on client side 

Read about migrating to VB.NET

Get information about declarations in VB.NET

Get answers to you VB.NET FAQs

Read a guide about VB.NET development

This was last published in November 2003

Dig Deeper on .NET tutorials, guides and quizzes

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchCloudComputing

SearchSoftwareQuality

SearchSOA

TheServerSide

SearchCloudApplications

Close