RE: Form Error when attempting to import MS Excel Spread***

From: Lance (latchley_at_landam.com)
Date: 02/03/05 

Date: Wed, 2 Feb 2005 21:50:36 -0800

Hi Wei-Dong;
  I've outlined the exact problem here:
1. Navigate to a page such as <site name>\Topics\location.
2. Selcet "Manage Content" option under "Actions".
3. Under Documents and Lists, click "Create".
4. Scroll down to "Custom Lists" click on "Import
Spead***".
5. On this form I enter the Name and then location of the
Excel spread***. (xls file). (The file has been saved
without interactivity.)
6. Then I click Import.
7. The file opens and then I receive an error
message "Microsoft Forms - Cannot load object because it
is not loaded on this machine". I click okay, then the
message appears a second time. I click okay again and the
Import diaglog box opens. Once I select the range of
cells to import and click okay I receive a second error
message "Compile Error, Variable not defined" and debugger
opens. I click Okay and close debugger.
8. Then I receive error "Unexpected error. -2147352567".

The server has been rebuilt fresh. It is running Windows
2003 Standard server. It has MS Office 2003 professional
installed, with MS SQL 2000. All service packs, hotfixes
and updates (as of 2/2/05) have been installed.

This behavior occurs on both the client system and the
server.

If I attempt this directly on the server, and uplaod the
spread*** to the document library first and then run the
import action (only on the server) it works okay.

I'm pretty baffled at this point.

Any help would be great. We are currenly planning on
deploying SPS 2003 in May, if I can show my boss that
these issues can be addressed/worked around.

Thanks
Lance

>-----Original Message-----
>Hi Lance,
>
>"import a spread*** through the manage content page on
a client system"
>Does this "import" mean uploading? From my understanding,
you are going to
>upload the spread*** into the Sharepoint doclib from
one client box. Am I
>right? If so, could you be so kind to tell me what file
format you are
>going to upload, Excel spread*** xml format or any
other?
>
>Expect your reply! I will perform research on this issue
for you then.
>
>Best Regards,
>Wei-Dong XU
>Microsoft Product Support Services
>
>When responding to posts, please "Reply to Group" via
your newsreader so
>that others may learn and benefit from your issue.
>=====================================================
>Business-Critical Phone Support (BCPS) provides you with
technical phone
>support at no charge during critical LAN outages
or "business down"
>situations. This benefit is available 24 hours a day, 7
days a week to all
>Microsoft technology partners in the United States and
Canada.
>This and other support options are available here:
>BCPS:
>https://partner.microsoft.com/US/technicalsupport/supporto
verview/40010469
>Others:
https://partner.microsoft.com/US/technicalsupport/supportov
erview/
>
>If you are outside the United States, please visit our
International
>Support page:
>http://support.microsoft.com/default.aspx?scid=%
2finternational.aspx.
>=====================================================
>Get Secure! - www.microsoft.com/security
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>