Link to home
Start Free TrialLog in
Avatar of DJ_Consulting
DJ_ConsultingFlag for United States of America

asked on

Opening launching excel 2010 from VB 2010

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.
Avatar of Ludovick Lagrevol
Ludovick Lagrevol
Flag of France image

Dim xlTmp As Excel.Application
 
  Set xlTmp = New Excel.Application
  xlTmp.Workbooks.Open "monexcel.xls"
Avatar of DJ_Consulting

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial