Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating Excel on a Server
OK, let's get over the "that's not supported" etc. I've read KB
articles 288366, 288367 and 257757. Very simply, I want to know if there is a way to automate Excel such that no one need be logged into the machine yet if an error does occur, someone can login to the machine and see the GUI. I've been experimenting with creating a service and having it run both as the SYSTEM account and as a particular user and also I've been playing with the Excel DCOM settings to have it run as interactive user or as a specific user. I can get the thing to run unattended, but I can't see the GUI when I log in. Does anyone have the solution? thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating Excel on a Server
Hi Matthew,
The behavior you observed is by design. Windows Stations and desktop objects are windows objects. A window station object will contain a few desktop objects. When you login, you will see a desktop, which is a visible desktop in a visible windows station. In this case you can launch the application such as excel, and you may see them visible. But when you launch them in another way, such as in the DCOM, or another specific user account , then they will run but not visible. In the KB Q288367 said that http://support.microsoft.com/?id=288367 COM create a unique WinStation for the new instance of the Office application. Any dialog boxes or warnings that may display do not appear on the interactive desktop. If you set the Visible flag for an application, the interactive user will not see that application. For more information about COM and WinStations, see the "References" section. Here is the link of References about WinStation. http://support.microsoft.com/default...b;EN-US;169321 Regards, Peter Huang Microsoft Online Partner Support Get Secure! www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights. -------------------- Date: Mon, 25 Aug 2003 15:49:22 -0400 From: Matthew Wieder User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en, he MIME-Version: 1.0 Subject: Automating Excel on a Server Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Newsgroups: microsoft.public.excel.programming NNTP-Posting-Host: 207.106.112.178 Lines: 1 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:409890 X-Tomcat-NG: microsoft.public.excel.programming OK, let's get over the "that's not supported" etc. I've read KB articles 288366, 288367 and 257757. Very simply, I want to know if there is a way to automate Excel such that no one need be logged into the machine yet if an error does occur, someone can login to the machine and see the GUI. I've been experimenting with creating a service and having it run both as the SYSTEM account and as a particular user and also I've been playing with the Excel DCOM settings to have it run as interactive user or as a specific user. I can get the thing to run unattended, but I can't see the GUI when I log in. Does anyone have the solution? thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Automating Excel | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
Excel 97 - automating getting info from web | Excel Discussion (Misc queries) | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) |