Opening Excel 2000 Workbook in asp

K

KADE

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)
 
K

K Dales

The obvious question: Is your file saved as an Excel 2000
file or is it Excel XP? If you are using Excel 2000 to
open the file (as you would be on the server) it probably
is having trouble recognizing the newer file format. If
possible, and if you haven't done it already, save the
file under 2000 format on the server.
 
K

KADE

Hi K. Dales
I actually saved the file down as a Microsoft Excel 97 (Excel 5.0,7.0) format (so older and newer versions can open it), so no, it's not saved as an Office XP file.
 
K

K Dales

Just had to check the most likely problem. Not sure then
why it hangs. What is the behavior on the server when it
hangs? Since you have set xlsApp.Visible it should be
visible on screen at that point. Do you get a partially
painted window? I have found that Excel 2000 hangs for me
when I try to open a file, leaving a partially painted
window, if there is a "rogue" Excel session left over
somewhere in memory. Just grasping at straws here...

K Dales
-----Original Message-----
Hi K. Dales,
I actually saved the file down as a Microsoft Excel 97
Click to expand...
(Excel 5.0,7.0) format (so older and newer versions can
open it), so no, it's not saved as an Office XP file.
 
K

KADE

Thanks again for the reply. Surprisingly, the Excel window doesn't show up when the script runs, which is strange. I actually just have Excel 2000 installed on the server - do you think I need to install the full Office suite?
 
K

K Dales

You should not need the full office suite, but you do need
to make sure the VBA files are there. Perhaps there are
some .dll files missing that prevent your code from
running - it is worth investigating.
-----Original Message-----
Thanks again for the reply. Surprisingly, the Excel
Click to expand...
window doesn't show up when the script runs, which is
strange. I actually just have Excel 2000 installed on the
server - do you think I need to install the full Office
suite?
 
K

K Dales

Try this: From your VBA editor, go to the Tools menu and
then References. Highlight any of them that are checked
off and at the bottom of the dialog you will see the
actual file path used by that reference. Then check the
server for the same.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
VB and I can't close the excel file 2
Subscript out of range error 5
Autonumber field in Excel that behaves the same as Access 0
inlineShape.OLEFormat.Activate() command fails for excel file 0
Merging from an Excel file with graphics 1
VBA code to modify Excel spreadsheet and then email it 2
Need Help with Macro Security 1

Top