LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Opening Excel 2000 Workbook in asp

Hi,
I've written code that opens an existing Excel file and
populates it with data from a database then closes it. I
tested it on my machine and it works fine (I have Office
XP installed), but when I port it to the server (which has
only Excel 2000 Sp3 installed), for some strange reason,
it always hangs at the point in where it's trying to open
the Excel file for edit.

Excel hangs and I usually have to stop it in task manager,
then I get the error code '800706be' on my browser for the
asp file. I've tried different things and I'm at a loss.
Any help would be much appreciated. The partial code is
below:


Set xlsApp = CreateObject("Excel.Application")
xlsApp.Visible = True
Set xlsBook = xlsApp.Workbooks.Open(xlsFile) *it hangs here

(xlsFile is a variable holding the filename and path of
the existing file)

 
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
Anyway of opening .xlsx in excel 2000? Roland Excel Discussion (Misc queries) 2 April 26th 07 11:34 PM
Opening XML in Excel 2000 molson1590 Excel Discussion (Misc queries) 1 April 23rd 07 07:44 AM
problem with opening hyperlink in excel 2000 Ruth Links and Linking in Excel 5 March 15th 06 06:06 PM
Excel 2000 shuts down after opening file thunderbird30 Setting up and Configuration of Excel 1 November 12th 05 03:14 PM
Opening an excel 2000 workbook in C# Lobo Excel Programming 0 October 2nd 03 02:44 PM


All times are GMT +1. The time now is 03:48 AM.

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"