Solved

Opening launching excel 2010 from VB 2010

Posted on 2013-06-13
3
168 Views
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.
0
Comment
Question by:DJ_Consulting
3 Comments
 
LVL 7

Expert Comment

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

Author Comment

by:DJ_Consulting
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.
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 39247143
Use following line

System.Diagnostic.Process.Start(filenamevariable)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
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.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

808 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