Solved

Read excel worksheet from vb.net in readonly mode

Posted on 2011-09-22
1
256 Views
Last Modified: 2012-06-27
This is my code:
        dim objExcel
        objExcel = CreateObject("Excel.Application")
        objExcel.Workbooks.open("c:\somefile.xlsx")
        objExcel.visible = True

How do I do to read this excel file in read only mode?
0
Comment
Question by:BemboX
1 Comment
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 36584563
objExcel.Workbooks.open("c:\somefile.xlsx",,True)
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question