Solved

Opening launching excel 2010 from VB 2010

Posted on 2013-06-13
3
170 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

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…
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

751 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