Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel return error code
Dear Excel Experts,
Please help! p.s. Rolling back the patch did not help. Gary "Joe Wu [MSFT]" wrote in message ... Dear Gary, Thank your for your post. I learned that the problem began to occur after applying the new MS03-026 security patch. However, I think the current news group is not the best one for this problem. To resolve this problem, you may need to check the code which uses the Excel OCX to generate the Excel reports. Therefore, I suggest that you post this question in the microsoft.public.excel.programming news groups, which is primarily for issues involving Excel development. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the newsgroups regularly can either share their knowledge or learn from your interaction with us. I hope the problem can be resolved quickly. Thank you for using our News Group. Regards, Joe Wu Product Support Services Microsoft Corporation Get Secure! - www.microsoft.com/security ================================================== == When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== == This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- |Content-Class: urn:content-classes:message |From: "Gary Lam" |Sender: "Gary Lam" |Subject: SQL server failed to call Excel's library after ms03-026 patch applied |Date: Thu, 14 Aug 2003 01:07:44 -0700 |Lines: 11 |Message-ID: |MIME-Version: 1.0 |Content-Type: text/plain; | charset="iso-8859-1" |Content-Transfer-Encoding: 7bit |X-Newsreader: Microsoft CDO for Windows 2000 |X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 |Thread-Index: AcNiOyQQwda9TzXcRPujDAHCc0qCAw== |Newsgroups: microsoft.public.security |Path: cpmsftngxa06.phx.gbl |Xref: cpmsftngxa06.phx.gbl microsoft.public.security:30878 |NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165 |X-Tomcat-NG: microsoft.public.security | |Hello, | |We have a SQL2K Ent. on W2K Eng. Adv server. This server |also has MS-Office97 installed because it needs to run a |night job and call Excel's library to generate reports in |Excel format. |It failed to do that after the patch been applied. Excel |returns error message shows "-2147417851 (Method "~" of |object "~" failed) |Please help!! |Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel return error code
Gary, Can you run the Excel application from that box or do you get the same error? If you can describe the data environment of your application and what you are doing in Excel in some detail? Thanks, Jim Jim Vita Microsoft Developer Support Microsoft Security Announcement: Have you installed the patch for Microsoft Security Bulletin MS03-026?*If not Microsoft strongly advises you to review the information at the following link regarding Microsoft Security Bulletin MS03-026 http://www.microsoft.com/security/se...s/ms03-026.asp and/or to visit Windows Update at http://windowsupdate.microsoft.com to install the patch. Running the SCAN program from the Windows Update site will help to insure you are current with all security patches, not just MS03-026. This posting is provided "AS IS" with no warranties, and confers no rights. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel return error code
Gary, After consulting some more with my collegues, it appears that this may be a known issue. As a workaround try modifying your code to use late, instead of early binding. Example: Instead of: Dim oApp as Excel.Application use: Dim oApp as object Thanks, Jim Jim Vita Microsoft Developer Support Microsoft Security Announcement: Have you installed the patch for Microsoft Security Bulletin MS03-026?*If not Microsoft strongly advises you to review the information at the following link regarding Microsoft Security Bulletin MS03-026 http://www.microsoft.com/security/se...s/ms03-026.asp and/or to visit Windows Update at http://windowsupdate.microsoft.com to install the patch. Running the SCAN program from the Windows Update site will help to insure you are current with all security patches, not just MS03-026. This posting is provided "AS IS" with no warranties, and confers no rights. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel to return Hiragana using code/char functions | Excel Discussion (Misc queries) | |||
Return a value for a known code | Excel Worksheet Functions | |||
Return a value for a known code | Excel Worksheet Functions | |||
Error in Excel 2007 code | Excel Discussion (Misc queries) | |||
Error Code 1004 when exporting from VB app to Excel 2007 | Excel Discussion (Misc queries) |