Solved

Opening launching excel 2010 from VB 2010

Posted on 2013-06-13
3
163 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
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.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now