By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,327 Members | 849 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,327 IT Pros & Developers. It's quick & easy.

Open Excel File

P: n/a
Hi, Good Day!

I'd like to open a excel file using VB.net.

I've added a COM reference (Microsoft Excel 9.0 Object Library) and written
the below coding,
I received an error saying that "COM object with CLSID {....} is either not
valid or not registered.

Dim aa As Excel.Workbooks

Dim bb As New Excel.Workbook()

bb = aa.Open("c:\aaa.xls")
Can someone help.
Thanks in advanced.

rgds,
Phoebe.

Nov 20 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
> I received an error saying that "COM object with CLSID {....} is either
not
valid or not registered.


You may have office installation issues.

Are you using Excel 97? If you are using Excel 2000 it means you have 2
different versions of Excel on your computer or you are accessing the wrong
library.

Make sure OWC10.dll exists and is registered.

If you don't know how to register it, or none of these work post back here
please.

Nov 20 '05 #2

P: n/a
Hi,

I can't find the dll--OWC10.dll that mentioned, wht shd i do now?

Thanks in advanced.

rgds,
Phoebe.

"scorpion53061" <Its the end of the world as we know it@here.com> wrote in
message news:#z*************@TK2MSFTNGP11.phx.gbl...
I received an error saying that "COM object with CLSID {....} is either not
valid or not registered.


You may have office installation issues.

Are you using Excel 97? If you are using Excel 2000 it means you have 2
different versions of Excel on your computer or you are accessing the

wrong library.

Make sure OWC10.dll exists and is registered.

If you don't know how to register it, or none of these work post back here
please.

Nov 20 '05 #3

P: n/a
> I can't find the dll--OWC10.dll that mentioned, wht shd i do now?

What version of office are you using?
Nov 20 '05 #4

P: n/a
http://office.microsoft.com/ProductUpdates/default.aspx

Go there and make sure you are updated. I suspect you need a service pack or
two.
Nov 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.