Visual studio 2005 vb2005/.net Interops problem

[Yooooda]

I am trying to write some small application in VB code in Visual Studio 2005. The programs need to be able to connect to both Access and Excel simultaneously. If I use the Imports microsoft.office.interops.excel by itself, I can use Dim oexcel as new excel.application and it works fine. When I add Imports microsoft.office.interops.excel it no longer likes the dim statement and any attempt to add an Access application results in an ambiguous application error.
Why can't I have new excel.application AND new access.application?
Thanks.

 

[Andrzejek]

If I use the [blue]Imports microsoft.office.interops.excel[/blue] by itself, I can use Dim oexcel as new excel.application and it works fine. When I add [blue]Imports microsoft.office.interops.excel [/blue]

Why do you Imports microsoft.office.interops.excel twice, and Access none?


Have fun.

---- Andy

 

[Yooooda]

Oops. Why the world still needs proofreaders.
I meant Imports Microsoft.office.interops.ACCESS