Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Read excel worksheet from vb.net in readonly mode

Posted on 2011-09-22
1
Medium Priority
?
264 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 2000 total points
ID: 36584563
objExcel.Workbooks.open("c:\somefile.xlsx",,True)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Loops Section Overview
Suggested Courses

963 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