CreateObject("Excel.Application") problem

10 Dec 2006 8:29 PM

Ultima

I'm trying to create an Excel file using a VB program. I have added the
reference to Excel Object Library yet when I try to compile it, I get
an error at the line exc_app = CreateObject("Excel.Application")

System.Exception was unhandled
Message="The remote server machine does not exist or is unavailable."
Source="Microsoft.VisualBasic"
StackTrace:

Do I need to turn on some kind of service in order to get this working?
What exactly does this error message mean?

11 Dec 2006 1:56 PM

Michel Posseth [MCP]

if you have set a reference , then you do not need create object at all

you just declare a object pointer as new

dim foo as new Excel.Application

Create object is used in the scenario of late binding

however both methods fail if the target computer does not have office
installed

regards

Michel

Show quoteHide quote

"Ultima" wrote:

> I'm trying to create an Excel file using a VB program. I have added the
> reference to Excel Object Library yet when I try to compile it, I get
> an error at the line exc_app = CreateObject("Excel.Application")
>
> System.Exception was unhandled
>   Message="The remote server machine does not exist or is unavailable."
>   Source="Microsoft.VisualBasic"
>   StackTrace:
>
> Do I need to turn on some kind of service in order to get this working?
> What exactly does this error message mean?
>
>

28 Dec 2006 6:04 PM

RobinS

Did you ever get this to work?
Robin S.
--------------------
Show quoteHide quote

"Ultima" <ultima_***@hotmail.com> wrote in message
news:1165782564.052450.200610@j44g2000cwa.googlegroups.com...
> I'm trying to create an Excel file using a VB program. I have added
> the
> reference to Excel Object Library yet when I try to compile it, I get
> an error at the line exc_app = CreateObject("Excel.Application")
>
> System.Exception was unhandled
> Message="The remote server machine does not exist or is unavailable."
> Source="Microsoft.VisualBasic"
> StackTrace:
>
> Do I need to turn on some kind of service in order to get this
> working?
> What exactly does this error message mean?
>