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

ADOX

P: n/a
Hello

I've been looking at information at the following link:

http://support.microsoft.com/default...BLN%5D;Q303814

and have tried the following in a VB.net application:

Dim cat As ADOX.Catalog
cat = New ADOX.Catalog
cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=" & "C:\book1.xls;Extended Properties=Excel 8.0"

i.e. virtually what is given in the Microsoft example.

However, when I run this I get the error message:

"Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another."

Can anybody help?

Phil

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


P: n/a
Phil,

Better to take this link what is VBNet you was using VBA/VB classic

http://msdn.microsoft.com/library/de...ntodataset.asp

I hope this helps?

Cor
"Phil" <putitinthepost@nowhere>
....
Hello

I've been looking at information at the following link:

http://support.microsoft.com/default...BLN%5D;Q303814

and have tried the following in a VB.net application:

Dim cat As ADOX.Catalog
cat = New ADOX.Catalog
cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=" & "C:\book1.xls;Extended Properties=Excel 8.0"

i.e. virtually what is given in the Microsoft example.

However, when I run this I get the error message:

"Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another."

Can anybody help?

Phil

Nov 21 '05 #2

P: n/a
Hello Cor

Unfortunately, this does not do what I need i.e. I'm trying to create an
excel file. The link I gave is supposed to work but it doesn't in VB
classic. I know the other way to do it is to use OLE but I'm wondering why
this "classic" code now fails.

Any ideas?

Phil

"Cor Ligthert" <no************@planet.nl> wrote in message
news:OX*************@TK2MSFTNGP14.phx.gbl...
Phil,

Better to take this link what is VBNet you was using VBA/VB classic

http://msdn.microsoft.com/library/de...ntodataset.asp

I hope this helps?

Cor
"Phil" <putitinthepost@nowhere>
...
Hello

I've been looking at information at the following link:

http://support.microsoft.com/default...BLN%5D;Q303814

and have tried the following in a VB.net application:

Dim cat As ADOX.Catalog
cat = New ADOX.Catalog
cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=" & "C:\book1.xls;Extended Properties=Excel 8.0"

i.e. virtually what is given in the Microsoft example.

However, when I run this I get the error message:

"Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another."

Can anybody help?

Phil


Nov 21 '05 #3

P: n/a
Phil,

I have here some links about Excel in VBNet

Office
http://support.microsoft.com/default...b;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

Excel dataset fill and updat
http://support.microsoft.com/default...b;EN-US;316934

Excel object model
http://msdn.microsoft.com/library/de...l/ExcelObj.asp

I hope that one of those works,

Otherwise maybe a VB classic newsgroup
microsoft.public.vb
and as advice than
microsoft.public.vb.general.discussion

I hope this helps

Cor
Nov 21 '05 #4

P: n/a
Thank you Cor, I will give them a look.

Phil

"Cor Ligthert" <no************@planet.nl> wrote in message
news:uC**************@TK2MSFTNGP10.phx.gbl...
Phil,

I have here some links about Excel in VBNet

Office
http://support.microsoft.com/default...b;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

Excel dataset fill and updat
http://support.microsoft.com/default...b;EN-US;316934

Excel object model
http://msdn.microsoft.com/library/de...l/ExcelObj.asp

I hope that one of those works,

Otherwise maybe a VB classic newsgroup
microsoft.public.vb
and as advice than
microsoft.public.vb.general.discussion

I hope this helps

Cor

Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.