473,242 Members | 1,481 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,242 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 11557
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Allison Bailey | last post by:
Hi Folks, I'm a brand new Python programmer, so please point me in the right direction if this is not the best forum for this question.... I would like to open an existing MS Excel spreadsheet...
3
by: Otie | last post by:
I found the following under the GetObject help notes and in the example for GetObject: "This example uses the GetObject function to get a reference to a specific Microsoft Excel worksheet...
6
by: Matthew Wieder | last post by:
I have the following requirements: Build a stand-alone C# application that asks the user to click in a cell in an Excel spreadsheet, and then displays the address of that cell in the C#...
17
by: Mansi | last post by:
I need to do some research on how to use excel automation from c#. Does anyone know of any good books related to this subject? Thanks. Mansi
5
by: Mike in Santa Rosa | last post by:
I'm trying to get a simple c# app built that can launch/manipulate an excel workbook, sheet. I've chased down several examples and can't any of them to work. So I must be doing somethnig obviouslt...
9
by: Doug Glancy | last post by:
I got the following code from Francesco Balena's site, for disposing of Com objects: Sub SetNothing(Of T)(ByRef obj As T) ' Dispose of the object if possible If obj IsNot Nothing AndAlso...
7
by: ddecoste | last post by:
I have a need to add a visual representation to some data in Access. I need to draw a matix of squares inside another square. I have all the data that I need in a record in Access. The data...
2
by: Nicholas Dreyer | last post by:
The following error Run-time exception thrown : System.Runtime.InteropServices.COMException - Error loading type library/DLL. happens while running the code listed at the bottom of this...
3
by: pleaseexplaintome_2 | last post by:
using the code below (some parts not included), I create a new excel workbook with spreadheets. I then want to delete a spreadsheet, but a reference remains open and excel stays in task manager...
13
by: chuckie_9497 | last post by:
hello all you gurus. I am struggling with releasing com objects. I have isolated the problem to the code below. Objects are released and the process ends until I use "int k = sheet.Count;" Then...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.