Opening launching excel 2010 from VB 2010

Posted on 2013-06-13
Medium Priority
Last Modified: 2013-06-19
What would be the proper code to launch an excel 2010 file from vb 2010?   I have the file name in a variable just not sure of the proper way to program the process.
Question by:DJ_Consulting

Expert Comment

ID: 39244933
Dim xlTmp As Excel.Application
  Set xlTmp = New Excel.Application
  xlTmp.Workbooks.Open "monexcel.xls"

Author Comment

ID: 39245247
Error	1	Type 'Excel.Application' is not defined.

Open in new window

     is what i'm getting I added the application under projects reference but still get the error.
LVL 83

Accepted Solution

CodeCruiser earned 1500 total points
ID: 39247143
Use following line


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
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.
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Suggested Courses

621 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