471,122 Members | 2,437 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,122 software developers and data experts.

Excel reference

Thanks in advance for any help. I'm having trouble with this code:

Dim xlsApp As Excel.Application
Dim xlsWB As Excel.Workbook
xlsApp = New Excel.Application
xlsApp.Visible = True

......

The problem is Excel.Application is not recognized. I have the Excell
11.0 object reference as well as the Office 11.0 reference (I can't
import Microsoft.Office.Interop.Excel either). Not sure what is going
on.

Any suggestions? I'm using VB 2005 Express.

Jun 13 '07 #1
4 11318
Looch,

I think what you are looking for is the Visual Studio Tools for Office. The
Express Editions do not support Office development.

You would need either the Visual Studio Tools for Office, or one of the
Visual Studio Team Editions.

http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx

Hope this helps,
Steve

"Looch" <lu**********@yahoo.comwrote in message
news:11**********************@j4g2000prf.googlegro ups.com...
Thanks in advance for any help. I'm having trouble with this code:

Dim xlsApp As Excel.Application
Dim xlsWB As Excel.Workbook
xlsApp = New Excel.Application
xlsApp.Visible = True

.....

The problem is Excel.Application is not recognized. I have the Excell
11.0 object reference as well as the Office 11.0 reference (I can't
import Microsoft.Office.Interop.Excel either). Not sure what is going
on.

Any suggestions? I'm using VB 2005 Express.

Jun 13 '07 #2
On Jun 13, 11:51 am, "PlatinumBay" <stevan...@community.nospamwrote:
Looch,

I think what you are looking for is the Visual Studio Tools for Office. The
Express Editions do not support Office development.

You would need either the Visual Studio Tools for Office, or one of the
Visual Studio Team Editions.

http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx

Hope this helps,

Steve

"Looch" <lucianoj2...@yahoo.comwrote in message

news:11**********************@j4g2000prf.googlegro ups.com...
Thanks in advance for any help. I'm having trouble with this code:
Dim xlsApp As Excel.Application
Dim xlsWB As Excel.Workbook
xlsApp = New Excel.Application
xlsApp.Visible = True
.....
The problem is Excel.Application is not recognized. I have the Excell
11.0 object reference as well as the Office 11.0 reference (I can't
import Microsoft.Office.Interop.Excel either). Not sure what is going
on.
Any suggestions? I'm using VB 2005 Express.
I think what you are looking for is the Visual Studio Tools for Office. The
Express Editions do not support Office development.
AFAIK, the Express editions work fine for Office development. The
following works fine after importing the COM reference to Microsoft
Excel 11.0 Object Library (no Import statements needed)

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim excel As New Excel.Application()
excel.Workbooks.Add()
excel.Visible = True
End Sub

End Class

Thanks,

Seth Rowe
Jun 13 '07 #3
On Jun 13, 12:20 pm, rowe_newsgroups <rowe_em...@yahoo.comwrote:
On Jun 13, 11:51 am, "PlatinumBay" <stevan...@community.nospamwrote:


Looch,
I think what you are looking for is the Visual Studio Tools for Office. The
Express Editions do not support Office development.
You would need either the Visual Studio Tools for Office, or one of the
Visual Studio Team Editions.
http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx
Hope this helps,
Steve
"Looch" <lucianoj2...@yahoo.comwrote in message
news:11**********************@j4g2000prf.googlegro ups.com...
Thanks in advance for any help. I'm having trouble with this code:
Dim xlsApp As Excel.Application
Dim xlsWB As Excel.Workbook
xlsApp = New Excel.Application
xlsApp.Visible = True
.....
The problem is Excel.Application is not recognized. I have the Excell
11.0 object reference as well as the Office 11.0 reference (I can't
import Microsoft.Office.Interop.Excel either). Not sure what is going
on.
Any suggestions? I'm using VB 2005 Express.
I think what you are looking for is the Visual Studio Tools for Office. The
Express Editions do not support Office development.

AFAIK, the Express editions work fine for Office development. The
following works fine after importing the COM reference to Microsoft
Excel 11.0 Object Library (no Import statements needed)

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim excel As New Excel.Application()
excel.Workbooks.Add()
excel.Visible = True
End Sub

End Class

Thanks,

Seth Rowe- Hide quoted text -

- Show quoted text -
Thanks for the replies. I had to remove and then re-add the Excel
reference, not sure why, but it worked. Thanks again.

Jun 13 '07 #4
On Jun 13, 1:06 pm, Looch <lucianoj2...@yahoo.comwrote:
On Jun 13, 12:20 pm, rowe_newsgroups <rowe_em...@yahoo.comwrote:
On Jun 13, 11:51 am, "PlatinumBay" <stevan...@community.nospamwrote:
Looch,
I think what you are looking for is the Visual Studio Tools for Office. The
Express Editions do not support Office development.
You would need either the Visual Studio Tools for Office, or one of the
Visual Studio Team Editions.
>http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx
Hope this helps,
Steve
"Looch" <lucianoj2...@yahoo.comwrote in message
>news:11**********************@j4g2000prf.googlegr oups.com...
Thanks in advance for any help. I'm having trouble with this code:
Dim xlsApp As Excel.Application
Dim xlsWB As Excel.Workbook
xlsApp = New Excel.Application
xlsApp.Visible = True
.....
The problem is Excel.Application is not recognized. I have the Excell
11.0 object reference as well as the Office 11.0 reference (I can't
import Microsoft.Office.Interop.Excel either). Not sure what is going
on.
Any suggestions? I'm using VB 2005 Express.
I think what you are looking for is the Visual Studio Tools for Office. The
Express Editions do not support Office development.
AFAIK, the Express editions work fine for Office development. The
following works fine after importing the COM reference to Microsoft
Excel 11.0 Object Library (no Import statements needed)
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim excel As New Excel.Application()
excel.Workbooks.Add()
excel.Visible = True
End Sub
End Class
Thanks,
Seth Rowe- Hide quoted text -
- Show quoted text -

Thanks for the replies. I had to remove and then re-add the Excel
reference, not sure why, but it worked. Thanks again.
Thanks for the replies. I had to remove and then re-add the Excel
reference, not sure why, but it worked. Thanks again.
If that's the worst thing Visual Studio ever does to you, you should
be happy :-)

Thanks,

Seth Rowe

Jun 13 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
6 posts views Thread by Matthew Wieder | last post: by
17 posts views Thread by Mansi | last post: by
5 posts views Thread by Mike in Santa Rosa | last post: by
9 posts views Thread by Doug Glancy | last post: by
3 posts views Thread by pleaseexplaintome_2 | last post: by
13 posts views Thread by chuckie_9497 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.