C# Discussion Boards - CodeProject

exception 0x800A03EC in excel

8-Mar-09 23:33

There's a forum under the article for questions to the author. Do you have .NET installed ?

Christian Graus

Driven to the arms of OSX by Vista.

abbd8-Mar-09 22:40

8-Mar-09 22:40

Hello,
i have an exception on the bold text code, but in another comptuer, this code work :

<br />
XlFixedFormatType paramExportFormat = XlFixedFormatType.xlTypePDF;<br />
                    XlFixedFormatQuality paramExportQuality =<br />
                    XlFixedFormatQuality.xlQualityStandard;<br />
                    bool paramOpenAfterPublish = false;<br />
                    bool paramIncludeDocProps = false;<br />
                    bool paramIgnorePrintAreas = true;<br />
                    object paramFromPage = Type.Missing;<br />
                    object paramToPage = Type.Missing;<br />
<br />
<br />
// Open the source workbook.<br />
                        excelWorkBook = excelApplication.Workbooks.Open(paramSourceBookPath,<br />
                        paramMissing, paramMissing, paramMissing, paramMissing,<br />
                        paramMissing, paramMissing, paramMissing, paramMissing,<br />
                        paramMissing, paramMissing, paramMissing, paramMissing,<br />
                        paramMissing, paramMissing);<br />
<br />
                        // Save it in the target format.<br />
                        if (excelWorkBook != null)<br />
                           <big> excelWorkBook.ExportAsFixedFormat(paramExportFormat,<br />
                            paramExportFilePath, paramExportQuality,<br />
                            paramIncludeDocProps, paramIgnorePrintAreas, paramFromPage,<br />
                            paramToPage, paramOpenAfterPublish,<br />
                            paramMissing);</big>

the office 2007 was installed, but there are always this exception, please help me to resolve this great problem, thank you verry mutch.

Christian Graus8-Mar-09 23:31

8-Mar-09 23:31

How about telling us the exception message, and what's different ( such as different office versions ) between the two machines ?

Christian Graus

Driven to the arms of OSX by Vista.

abbd9-Mar-09 0:51

9-Mar-09 0:51

It is the same version of office, it's office 2007 plus, thank you verry mutch.

Rutvik Dave9-Mar-09 10:47

9-Mar-09 10:47

OK. But what error message you are getting ?

I think (just a guess) that you dont have correct filepath. i.e. you are using D:\xyz and D: is not there or xyz is not there.

or try this.

in Office 2007

*) Open the 2007 Microsoft Office system application in question. Click the Microsoft Office button, and then click Application Options. 
*) Click the Trust Center tab, and then click Trust Center Settings. 
*) Click the Macro Settings tab, click to select the Trust access to the VBA project object model check box, and then click OK. 
*) Click OK.

Or try opening excel application (manually) and then run your code.

abbd10-Mar-09 5:54

10-Mar-09 5:54

Thank you verry mutch for your answer but it doesn't work, in a computer it's the same parameter's of office and it work but in my pc it don't work, i try to install microsoft office 2003 and it the same, please help me to resolve this problem, thank you verry mutch.

Rutvik Dave10-Mar-09 6:17

10-Mar-09 6:17

But what is the error message you are getting ?

Try this one.

1. Click Start, click Run, and then type DCOMCNFG. Select the application that we want to automate. The application names are listed below:

2. Microsoft Excel 97/2000/2002/2003 - Microsoft Excel Application

3. Click Properties to open the property dialog box for this application.

4. Click the Security tab. Verify that Use Default Access Permissions and Use Default Launch Permissions are selected.
5. Click the Identity tab. Verify that The Launching User is selected.
6. Click OK to close the property dialog box and return to the main applications list dialog box.
7. In the DCOM Configuration dialog box, click the Default Security tab.
8. Click Edit Defaults for access permissions. Verify that the following users are listed in the access permissions, or add the users if they are not listed:

SYSTEM
INTERACTIVE
Everyone
Administrators
OfficeAutomationUser
IUSR_<machinename>*
IWAM_<machinename>*

* These accounts exist only if Internet Information Server (IIS) is installed on the computer.

9.Make sure that each user is allowed access and click OK.
Click Edit Defaults for launch permissions. Verify that the following users are listed in the launch permissions, or add the users if they are not listed:

SYSTEM
INTERACTIVE
Everyone
Administrators
OfficeAutomationUser
IUSR_<machinename>*
IWAM_<machinename>*

* These accounts exist only if IIS is installed on the computer.

abbd10-Mar-09 6:39

10-Mar-09 6:39

When i excute DCOMCNFG, a table appear, there are a root : consol and thre fields : services composant, services and log file, but i don't find microsoft excel 2003 or 2007, thank you verry mutch.

Rutvik Dave10-Mar-09 7:01

10-Mar-09 7:01

in "DCOMCNFG"

Go to

Component Service
Computers
My Computer
DCOM Config
now select from right hand side list

abbd10-Mar-09 8:44

10-Mar-09 8:44

I am sorry bu I don't find goto, Thank you verry mutch

Rutvik Dave10-Mar-09 10:19

mail sending using proxy server

10-Mar-09 10:19

come on man. Big Grin | :-D

Go to means "Select"

When you open "dcomcnfg"

On the Left hand side panel under the "Console Root" Select those options in the tree view (click +)

And after you select the last node find the excel application on the right hand side panel. Smile | :)

anupmadathil8-Mar-09 22:36

anupmadathil

8-Mar-09 22:36

Hi,

I am trying to send email through C# using my Gmail account.When i am running this application from direct internect connection system its working fine. when i am using a proxy system its showing 'Failure sending mail'.

i am using the code

SmtpClient SmtpServer = new SmtpClient();
SmtpServer.Credentials = new System.Net.NetworkCredential ("username","password");
SmtpServer.Port = 587;
SmtpServer.Host = "smtp.gmail.com";
SmtpServer.EnableSsl = true;
mail = new MailMessage();
mail.From = "";
mail.Subject = "";
SmtpServer.Send(mail);

Thanks in advance
AnupMadathil

Re: mail sending using proxy server

Christian Graus8-Mar-09 23:30

Using BHO, how can I detect when a PDF file is opened on IE?

8-Mar-09 23:30

I don't believe that the .NET email classes have ways to set a proxy server.

Christian Graus

Driven to the arms of OSX by Vista.

svt gdwl8-Mar-09 21:42

svt gdwl

8-Mar-09 21:42

Hi,
I want to access the data of a PDF file which is opened on IE using BHO.
Using a Browser Helper Object, how can I come to know that a PDF file is opened on IE.

The BHO in the following link is helpful for retrieving data of web pages.

http://www.codeproject.com/KB/cs/Attach_BHO_with_C_.aspx?fid=447248&df=90&mpp=25&noise=3&sort=Position&view=Quick&fr=51&select=2421069

But how the PDF file data can be retrieved?

how to read a encrypted html? need help

YiXiang_898-Mar-09 21:31

YiXiang_89

8-Mar-09 21:31

Hi everyone, i need your help
This is my sym.cs file where it store the encryption part

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Security.Cryptography;

namespace SecurePDFViewer
{
public class SymCrypto
{
private SymmetricAlgorithm symAlgorithm;

private static byte[] saltValue = new byte[] {213,230,110,217,191,69,82,238};
private static byte[] IV = new byte[] { 207, 177, 154, 229, 191, 104, 44, 244, 86, 12, 63, 54, 94, 9, 88, 148 };
private static int keySize = 256;
private static int pwIteration = 7;

public SymCrypto()
{
//Creates the default implementation, which is RijndaelManaged 256 bits
symAlgorithm = SymmetricAlgorithm.Create();
symAlgorithm.IV = IV;
}

public SymCrypto(string algorithmName)
{
symAlgorithm = SymmetricAlgorithm.Create(algorithmName);
symAlgorithm.KeySize = keySize;
symAlgorithm.IV = IV;
}

public byte[] EncryptData(string passphrase, byte[] plainBytes)
{
GenerateKey(passphrase);

// Define memory stream which will be used to hold encrypted data
MemoryStream memoryStream = new MemoryStream();

// Define cryptographic stream (Write mode for encryption)
CryptoStream cryptoStream = new CryptoStream(memoryStream,
symAlgorithm.CreateEncryptor(),
CryptoStreamMode.Write);

cryptoStream.Write(plainBytes, 0, plainBytes.Length);
cryptoStream.FlushFinalBlock();

byte[] cipherBytes = memoryStream.ToArray();

// Close streams
memoryStream.Close();
cryptoStream.Close();

return cipherBytes;
}

public string EncryptData(string passphrase, string plainText)
{
byte[] plainTextBytes = Encoding.UTF8.GetBytes(plainText);
return Convert.ToBase64String(EncryptData(passphrase, plainTextBytes));
}

public byte[] DecryptData(string passphrase, byte[] cipherBytes)
{
GenerateKey(passphrase);

// Define memory stream which will be used to hold encrypted data
MemoryStream memoryStream = new MemoryStream(cipherBytes);

// Define cryptographic stream (Read mode for decryption)
CryptoStream cryptoStream = new CryptoStream(memoryStream,
symAlgorithm.CreateDecryptor(),
CryptoStreamMode.Read);

byte[] plainBytes = new byte[cipherBytes.Length];
int count = cryptoStream.Read(plainBytes, 0, plainBytes.Length);

// Close streams
memoryStream.Close();
cryptoStream.Close();

byte[] actualBytes = new byte[count];
for (int i = 0; i < count; i++)
{
actualBytes[i] = plainBytes[i];
}

return actualBytes;
}

public string DecryptData(string passphrase, string cipherText)
{
byte[] cipherTextBytes = Convert.FromBase64String(cipherText);
return Encoding.UTF8.GetString(DecryptData(passphrase, cipherTextBytes), 0, 1000);
}

private void GenerateKey(string passphrase)
{
Rfc2898DeriveBytes pwdGen = new Rfc2898DeriveBytes(passphrase, saltValue, pwIteration);
symAlgorithm.Key = pwdGen.GetBytes(keySize/8);
}
}
}

------------------------------------------------------------------------------------------------------

Main.cs

using System.IO;
using System.Security.Cryptography;

private void button1_Click(object sender, EventArgs e)
{
SymCrypto sym = new SymCrypto();

string cipherText = sym.EncryptData("I love Java", "2.1 SCOPE OF TESTS\nThe test plan for User Authentication System webservice will consist \nof the following tests related to interoperability: a) WS-I Basic Profile 1.1 Interoperability Tests Interoperability testing will be performed in conformance to WS-I Basic Profile 1.1 specifications. The profile addresses the following areas: \n• Messaging Messaging includes XML Representation of SOAP Messages, SOAP Processing Model and use of SOAP in HTTP. Four specifications are referenced in this section:• Simple Object Access Protocol (SOAP) 1.1• Extensible Markup Language (XML) 1.0 (Second Edition)• RFC26116 Hypertext Transport Protocol HTTP/ 1.1 • RFC2965: HTTP State Management Mechanism• Service DescriptionThis refers to Web Services Description Language (WSDL) to enable the description of services as sets of endpoints operating on messages. Three specifications and extensibility points are referenced in this section:• Web Services Description Language 1.1• XML Schema Part 1: Structures•"); <---- HARD CODE
string abc = ("how are you"); <-- HARD CODE
MessageBox.Show(cipherText + abc);
string plainText = sym.DecryptData("I love Java", cipherText);
MessageBox.Show(plainText + abc);
}

------------------------------------------------------------------------------------------------------

I will be using a IE toolbar button to mark it...
But how can change it so that i can read the encrypted html?

Thank you

Re: how to read a encrypted html? need help

Christian Graus8-Mar-09 23:28

Re: how to read a encrypted html? need help

8-Mar-09 23:28

We didn't need to see all this code. So, you're saying you can decrypt it, but you want to display it in IE via a toolbar ? So, you want to intercept an HTTP request and decode it, right ?

Does it have to be in a toolbar, could it be in an app that contains an IE control and then does the HTTP request ?

Christian Graus

Driven to the arms of OSX by Vista.

YiXiang_898-Mar-09 23:58

YiXiang_89

8-Mar-09 23:58

No,
Cause this encrypt is hardcode
How can i do like this: Use getElementsByName()

if my
var x=document.getElementsByName("encrypt");

How can i capture those encrypt in the html and ancrypt it?

text"

text

Re: how to read a encrypted html? need help

YiXiang_898-Mar-09 23:58

YiXiang_89

8-Mar-09 23:58

No,
Cause that encrypt words is hardcoded
How can i do like this: Use getElementsByName()

if my
var x=document.getElementsByName("encrypt");

How can i capture those encrypt in the html and ancrypt it?

text"

text

can u plz tell me that whether we can import microsoft word objects(lines,circles,etc...) into the microsoft .net framework. how to do that one?

Kanchan Pawar8-Mar-09 21:30

Kanchan Pawar

8-Mar-09 21:30

urgent...........

Re: can u plz tell me that whether we can import microsoft word objects(lines,circles,etc...) into the microsoft .net framework. how to do that one?

Ashfield8-Mar-09 21:55

Ashfield

8-Mar-09 21:55

Kanchan Pawar wrote:
urgent...........

No its not.

You obviously do NOT know what you are talking about, the microsoft .net framework is not something you can import anything into, its a code for running applications.

I suugest you get some books about .net and read them before going any further.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: can u plz tell me that whether we can import microsoft word objects(lines,circles,etc...) into the microsoft .net framework. how to do that one?

ABitSmart8-Mar-09 22:09

ABitSmart

8-Mar-09 22:09

I suggest you need a new keyboard first. Your period (".") key is malfunctioning.

Re: can u plz tell me that whether we can import microsoft word objects(lines,circles,etc...) into the microsoft .net framework. how to do that one?

Pete O'Hanlon8-Mar-09 23:09

Pete O'Hanlon

8-Mar-09 23:09

Kanchan Pawar wrote:
urgent...........

I assume you were expecting Intellisense to tell you what appeared after the first period. Continuing to press the key after the first one failed to do what you want is just an exercise in futility.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys

Re: can u plz tell me that whether we can import microsoft word objects(lines,circles,etc...) into the microsoft .net framework. how to do that one?

Christian Graus8-Mar-09 23:19