Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only CreateObject Syntax works.
Hai,
I am facing a problem while working with Excel object in VB. I have added a reference to Excel 10.0 object library, but i am unable to create a Excel.Application object. (I have Office XP installed in my system.) like Dim objExcel as New Excel.Application ( here the intellisense is not showing Excel) but i am able to do usign Createobject syntax. What could be the problem.. Thanks. V.Boomessh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only CreateObject Syntax works.
Could be other reference that caused the problem.
I managed to do that like Option Explicit Dim mexcel As Excel.Application Public Sub openexcel(ByVal s As String, ByRef item As MailItem) Dim fso As New FileSystemObject Dim rec As Recordset Set mexcel = New Excel.Application End Sub -- Lucotus "Boomessh" wrote: Hai, I am facing a problem while working with Excel object in VB. I have added a reference to Excel 10.0 object library, but i am unable to create a Excel.Application object. (I have Office XP installed in my system.) like Dim objExcel as New Excel.Application ( here the intellisense is not showing Excel) but i am able to do usign Createobject syntax. What could be the problem.. Thanks. V.Boomessh |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only CreateObject Syntax works.
Hai ,
THanks for your reply, but when i write Dim objExcel as Excel ( and on keeping "." the intellisense gives me only Adjustments Class and NOt Application. I have even reinstalled the OFFICE, but no use. Guide me, thanks, V.Boomessh "lucotuslim" wrote: Could be other reference that caused the problem. I managed to do that like Option Explicit Dim mexcel As Excel.Application Public Sub openexcel(ByVal s As String, ByRef item As MailItem) Dim fso As New FileSystemObject Dim rec As Recordset Set mexcel = New Excel.Application End Sub -- Lucotus "Boomessh" wrote: Hai, I am facing a problem while working with Excel object in VB. I have added a reference to Excel 10.0 object library, but i am unable to create a Excel.Application object. (I have Office XP installed in my system.) like Dim objExcel as New Excel.Application ( here the intellisense is not showing Excel) but i am able to do usign Createobject syntax. What could be the problem.. Thanks. V.Boomessh |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only CreateObject Syntax works.
I don't use VB, but how about trying:
dim objExcel as Excel.Application set objexcel = new excel.application This kind of thing works ok for me in MSWord (with that reference set). Actually, both these worked ok (from MSWord): Option Explicit Sub testme() Dim objExcel As Excel.Application Set objExcel = New Excel.Application objExcel.Visible = True objExcel.Workbooks.Add End Sub Sub testme2() Dim objExcel As New Excel.Application objExcel.Visible = True objExcel.Workbooks.Add End Sub Any chance that excel is just closing before you want it to close. I had to do something in excel (workbooks.add was enough) to keep it open after both of the routines ran. Boomessh wrote: Hai, I am facing a problem while working with Excel object in VB. I have added a reference to Excel 10.0 object library, but i am unable to create a Excel.Application object. (I have Office XP installed in my system.) like Dim objExcel as New Excel.Application ( here the intellisense is not showing Excel) but i am able to do usign Createobject syntax. What could be the problem.. Thanks. V.Boomessh -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To CreateObject In VB To AutoCad | Excel Programming | |||
Createobject (repost) | Excel Programming | |||
CREATEOBJECT Using VB | Excel Programming | |||
Difference between NEW and CREATEOBJECT? | Excel Programming | |||
Templates and CreateObject | Excel Programming |