Re: Using Excel with Automation from a web page

From: jaf (johnf87@kohotmail.com)
Date: 06/03/02 

From: "jaf" <johnf87@kohotmail.com>
Date: Mon, 3 Jun 2002 06:39:05 -0400

Hi Martijn,
Please copy and paste the sub you are using into a post. re: getobject.

GetObject is used to find an open Excel.Application
I don't think it will find a file.

John

"Martijn Coppoolse" <newsgroups@martijn.coppoolse.com> wrote in message
news:OcZdq5sCCHA.2232@tkmsftngp04...
> Ok, thanks.
>
> But does anybody know what the problem could be, and/or how to solve it??
>
> > Apologies for the cross-posting.
> > We're running a web application that's supposed to extract data from an
> > Excel sheet into a database. For this, we use an ASP pages. In the ASP
> > page, we create a VB object. That object then tries to open an Excel
sheet
> > on the network by calling the excel automation interface (GetObject
> > ("\\computer\share\folder\sheet.xls")).
> >
> > Now when we run the client and the server on the same machine, it works
> > fine: on the development machine, which runs its own server, ok. On the
> Web
> > server, when using IE on the same machine, ok. When using IE on any
other
> > machine to call the web server, we get 'Permission denied' on the
creation
> > of the Excel application object.
> >
> > We've already tried to add the IUSR_-account to the Administrators
group,
> > but that didn't help.
> >
> > Any idea how to solve this? Or at least, where exactly the problem
lies?
>
> Thanks,
> --
> Martijn <@> Coppoolse <.com>
>
> "The Duke had a mind that ticked like a clock, and, like a clock, it
> regularly went cuckoo."
> -- Terry Pratchett
>
>
> "jaf" <johnf87@kohotmail.com> wrote in message
> news:#RSdJNLCCHA.2072@tkmsftngp02...
> > Hi Martijn,
> > Yes. That's the ticket. ;<)
> >
> >
> > John
> >
> >
> > "Martijn Coppoolse" <newsgroups@martijn.coppoolse.com> wrote in message
> > news:#WE#ozKCCHA.1660@tkmsftngp02...
> > > It is. Why? (Sorry: I guess it should be
> > > \\computer\share\folder\sheet.xls)
> > > --
> > > Martijn <@> Coppoolse <.com>
> > >
> > > "The Duke had a mind that ticked like a clock, and, like a clock, it
> > > regularly went cuckoo."
> > > -- Terry Pratchett
> > >
> > >
> > > "jaf" <johnf87@kohotmail.com> wrote in message
> > > news:upUhAjJCCHA.2064@tkmsftngp02...
> > > > Is share a computer name?
> > > >
> > > >
> > > > John
> > > >
> > > > "Martijn Coppoolse" <newsgroups@martijn.coppoolse.com> wrote in
> message
> > > > news:eWu0f7HCCHA.2040@tkmsftngp04...
> > > > > Hello,
> > > > >
> > > > > Apologies for the cross-posting.
> > > > >
> > > > > We're running a web application that's supposed to extract data
from
> > an
> > > > > Excel sheet into a database. For this, we use an ASP pages. In
the
> > ASP
> > > > > page, we create a VB object. That object then tries to open an
Excel
> > > sheet
> > > > > on the network by calling the excel automation interface
> > > > > (GetObject("\\share\folder\sheet.xls")).
> > > > >
> > > > > Now when we run the client and the server on the same machine, it
> > works
> > > > > fine: on the development machine, which runs its own server, ok.
On
> > the
> > > > Web
> > > > > server, when using IE on the same machine, ok. When using IE on
any
> > > other
> > > > > machine to call the web server, we get 'Permission denied' on the
> > > creation
> > > > > of the Excel application object.
> > > > >
> > > > > We've already tried to add the IUSR_-account to the Administrators
> > > group,
> > > > > but that didn't help.
> > > > >
> > > > > Any idea how to solve this? Or at least, where exactly the
problem
> > > lies?
> > > > >
> > > > > Thanks in advance,
> > > > > --
> > > > > Martijn <@> Coppoolse <.com>
> > > > >
> > > > > "The Duke had a mind that ticked like a clock, and, like a clock,
it
> > > > > regularly went cuckoo."
> > > > > -- Terry Pratchett
>
>

Relevant Pages

  • Re: enumerates Excel windows
    ... Private Declare Function GetDesktopWindow Lib "user32.dll" As Long ... where the filename is known use GetObject to ... The first enumerates Excel windows, then workbook windows to find the file ...
    (microsoft.public.excel.programming)
  • Re: Application.Visible=False
    ... unhide the hidden excel application. ... Set myXL = GetObject(, "Excel.Application") ... msgbox "Excel is not running" ... On Error GoTo 0 ...
    (microsoft.public.excel.programming)
  • Re: Aktive Excel-Applikation als Objekt einbinden
    ... Ein verbessertes GetObject 'zu Fuß' nachzubilden scheint ... Das 'falsche' Excel zu löschen geht nicht, ... > GetObject durchsucht die Running Object Tabelle (ROT). ...
    (microsoft.public.de.vb)
  • enumerates Excel windows
    ... Can you share code that enumerates multiple Excel windows. ... where the filename is known use GetObject to reference ... then workbook windows to find the file ...
    (microsoft.public.excel.programming)
  • Re: Closing Excel
    ... Dim xlApp As Excel.Application ... Set xlApp = GetObject(, "Excel.Application") ... A few lines to move data from Excel to Word ...
    (microsoft.public.word.vba.general)