Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default automate excel 2003 from VB6

Here is the problem:

I Have a vb 6 app that uses excel version 2003 in the code. Everything
works file on a desktop. However when running on a Windows 2000 Server in
the production environment it fails. I know the reason why, because excel is
not loaded on the production server. I'm getting pushback from the Windows
2000 Server box administrator about loading excel.exe on the production
server. This is preventing the automation of this job, and I was wondering
what details I could provide to the administrator to help sway his decision.

His arguement is that excel.exe is a desktop tool, and not to be loaded or
ran on the Windows 2000 Server box. Any talking points would be much
appreciated.
Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,953
Default automate excel 2003 from VB6

these may be more talking points for the administrator:

http://support.microsoft.com/kb/257757/en-us
Considerations for server-side Automation of Office

--
Regards,
Tom Ogilvy


"thekichler" wrote:

Here is the problem:

I Have a vb 6 app that uses excel version 2003 in the code. Everything
works file on a desktop. However when running on a Windows 2000 Server in
the production environment it fails. I know the reason why, because excel is
not loaded on the production server. I'm getting pushback from the Windows
2000 Server box administrator about loading excel.exe on the production
server. This is preventing the automation of this job, and I was wondering
what details I could provide to the administrator to help sway his decision.

His arguement is that excel.exe is a desktop tool, and not to be loaded or
ran on the Windows 2000 Server box. Any talking points would be much
appreciated.
Thanks in advance.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default automate excel 2003 from VB6

Can the workbook files on the server be made available to the workstations?
Have the administrator make a network drive on the server that can be
accessed from your workstation.

You have to compare the cost of installing office on every desk top verses
the cost of installing office on the server. If everybody who is going to
use the workbook has Office and has access to the server (network drive) then
it doesn't make sense to install excel on the server.

"thekichler" wrote:

Here is the problem:

I Have a vb 6 app that uses excel version 2003 in the code. Everything
works file on a desktop. However when running on a Windows 2000 Server in
the production environment it fails. I know the reason why, because excel is
not loaded on the production server. I'm getting pushback from the Windows
2000 Server box administrator about loading excel.exe on the production
server. This is preventing the automation of this job, and I was wondering
what details I could provide to the administrator to help sway his decision.

His arguement is that excel.exe is a desktop tool, and not to be loaded or
ran on the Windows 2000 Server box. Any talking points would be much
appreciated.
Thanks in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you automate numbers in Excel? Heather Stokes Excel Discussion (Misc queries) 2 July 11th 06 05:48 AM
Is there a way to automate google searches into excel? bxc2739 Excel Discussion (Misc queries) 4 April 24th 06 05:12 PM
How can I automate something to be added to a formula in excel? Reepicheep Excel Worksheet Functions 1 November 17th 05 02:26 PM
how to automate invoice using excel database Kathy Powercraft Excel Discussion (Misc queries) 1 October 6th 05 02:29 PM
automate creation of sheets in excel Daniel Excel Worksheet Functions 1 June 23rd 05 10:06 PM


All times are GMT +1. The time now is 03:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"