Replies

Many thanks Jan … I will be trying it this week.

Hi Mark and Charlotte,
I agree with you and like you am learning C# because my work demands it. I’m reading “Visual C#.Net : A guide for VB6 Developers”. Wrox Press. I’m finding it very useful. I miss VB’s case insensitivity. In the Wrox book it says, “Microsoft has developed this new langugage taking the best of many languages, making it easy and powerful, and has even used it to write the FCL. Microsoft is pushing to make C# the lead language for .NET programming.”

I’m having to learn so many new concepts: inheritance, polymorphism, constructors and destructors and namespaces, overloading, free threading, delegation – and these are all in VB.NET and C#.NET, so it doesn’t seem a big burden to also learn a new, more elegant language, which takes the best of java and VB and other languagues.

“in for a penny; in for a pound” …whatever that means

Hi Mark and Charlotte,
I agree with you and like you am learning C# because my work demands it. I’m reading “Visual C#.Net : A guide for VB6 Developers”. Wrox Press. I’m finding it very useful. I miss VB’s case insensitivity. In the Wrox book it says, “Microsoft has developed this new langugage taking the best of many languages, making it easy and powerful, and has even used it to write the FCL. Microsoft is pushing to make C# the lead language for .NET programming.”

I’m having to learn so many new concepts: inheritance, polymorphism, constructors and destructors and namespaces, overloading, free threading, delegation – and these are all in VB.NET and C#.NET, so it doesn’t seem a big burden to also learn a new, more elegant language, which takes the best of java and VB and other languagues.

“in for a penny; in for a pound” …whatever that means

I’m so happy I could jump for joy! Thank you – the square brackets worked! I’m so used to VBA that I never think of square brackets.

Mark – do you have any words of wisdom about when to use square brackets?

I’m so happy I could jump for joy! Thank you – the square brackets worked! I’m so used to VBA that I never think of square brackets.

Mark – do you have any words of wisdom about when to use square brackets?

Hi Mark – duh! I forgot to say that this line generates an error.

this.calloutDS.Tables(dataTable.TableName.ToString()).ImportRow(row);

I get a compile-time error message which is incomprehensible to me: “Cannot apply indexing with [] to an expression of type ‘System.Data.Dataset’.
It works fine if I substitute a literal in quotes, e.g.

this.calloutDS.Tables(“Persons”).ImportRow(row);

But then I’d have to write a separate little routine for each table …

Thanks Stuart. I think I know how it happened … I was in a dither both times when I bought the certificates from Comodo … and I was clicking the BACK button in the browser to go back and make sure I was really getting the right kind of certificate. I noticed that this caused the private key “mykey.pvk” to get downloaded more than once but I didn’t worry about it. I guess when they issued the public key to me, I paid the consequencies because their server must generate a new private key each time.

The bad news is that I just bought a [much more expensive] cert from Thawte and, again, I was clicking the BACK button and I think I got the private key more than once. But at least, this time, if it doesn’t work, I’ll know exactly what to tell the support people.

Warning to all who read this : WHEN BUYING A CODE SIGNING CERTIFICATE DO NOT USE BACK BUTTON IN BROWSER.

Thank you Stuart!

Thanks Stuart. I think I know how it happened … I was in a dither both times when I bought the certificates from Comodo … and I was clicking the BACK button in the browser to go back and make sure I was really getting the right kind of certificate. I noticed that this caused the private key “mykey.pvk” to get downloaded more than once but I didn’t worry about it. I guess when they issued the public key to me, I paid the consequencies because their server must generate a new private key each time.

The bad news is that I just bought a [much more expensive] cert from Thawte and, again, I was clicking the BACK button and I think I got the private key more than once. But at least, this time, if it doesn’t work, I’ll know exactly what to tell the support people.

Warning to all who read this : WHEN BUYING A CODE SIGNING CERTIFICATE DO NOT USE BACK BUTTON IN BROWSER.

Thank you Stuart!

Hi Stuart,
Yesterday I requested my $$ back from Comodo and I have received it today. I’m going to try another certificate authority. However, I still have the certificate from Comodo on my machine. If I could get it working, I’d re-pay them, if you know what I mean.

To answer your questions:
>1. ….. and click View. Look on the General tab. Does it include the text “You have a private key that corresponds to this certificate” . ANSWER: Nope.

>2. On the same dialog box, look in the details tab. Anything seem amiss? What are the Valid from and Valid to dates for the certificate? On the Certification Path tab do you see the words “The certificate is OK”? ANSWER: Everyting looks OK and “The Certificate is OK” is displayed.

>3. ANSWER: In Word, (with Security set to Medium) I go to the IDE, and open a module in my Normal.dot template, choose TOOLS > Digital Signature. I see “The VBA project is currently signed as [No certificate]. Click Choose button and select the Comodo certificate (the only one listed). Click OK. Now I see “The VBA project is currently signed as Ellwood & Assoc. (which is my cert name). Click OK.

Everything is lovely – if I go back to check in Tools > Digital Signature, it’s still there. But THEN I click the SAVE button and wham! when I go back to Tools > Digital Signature, the darn thing has gone back to “The VBA project is currently signed as [No certificate].

The Comodo certificate is only $99 and they authorized me quickly with minimum documentation (as I’m not incorporated) , so I would love to use them, but I’m moving on to Thawte now.

Thank you so much … I’ll keep you posted on how it goes with Thawte.

Hi Stuart,
Yesterday I requested my $$ back from Comodo and I have received it today. I’m going to try another certificate authority. However, I still have the certificate from Comodo on my machine. If I could get it working, I’d re-pay them, if you know what I mean.

To answer your questions:
>1. ….. and click View. Look on the General tab. Does it include the text “You have a private key that corresponds to this certificate” . ANSWER: Nope.

>2. On the same dialog box, look in the details tab. Anything seem amiss? What are the Valid from and Valid to dates for the certificate? On the Certification Path tab do you see the words “The certificate is OK”? ANSWER: Everyting looks OK and “The Certificate is OK” is displayed.

>3. ANSWER: In Word, (with Security set to Medium) I go to the IDE, and open a module in my Normal.dot template, choose TOOLS > Digital Signature. I see “The VBA project is currently signed as [No certificate]. Click Choose button and select the Comodo certificate (the only one listed). Click OK. Now I see “The VBA project is currently signed as Ellwood & Assoc. (which is my cert name). Click OK.

Everything is lovely – if I go back to check in Tools > Digital Signature, it’s still there. But THEN I click the SAVE button and wham! when I go back to Tools > Digital Signature, the darn thing has gone back to “The VBA project is currently signed as [No certificate].

The Comodo certificate is only $99 and they authorized me quickly with minimum documentation (as I’m not incorporated) , so I would love to use them, but I’m moving on to Thawte now.

Thank you so much … I’ll keep you posted on how it goes with Thawte.

(Edited by HansV to make URL clickable – see Help 19)

Hi Stuart,
>Have you installed your certificate yet?
I’m not sure … when I look in IE, Tools > Internet Options > Content > Certificates, I can see it and it says “Certificate Intended Purposes: Code Signing”.

While researching my problem I found at the Thawte site instructions to run PVK Digital Certificate Files Importer (http://www.microsoft.com/downloads/details…;displaylang=EN[/url]) but this has not helped as I get a “command line error” when trying to run it.

When I try to sign my VBA code, it appears to work, until I try to save the file and then I get the error.

(Edited by HansV to make URL clickable – see Help 19)

Hi Stuart,
>Have you installed your certificate yet?
I’m not sure … when I look in IE, Tools > Internet Options > Content > Certificates, I can see it and it says “Certificate Intended Purposes: Code Signing”.

While researching my problem I found at the Thawte site instructions to run PVK Digital Certificate Files Importer (http://www.microsoft.com/downloads/details…;displaylang=EN[/url]) but this has not helped as I get a “command line error” when trying to run it.

When I try to sign my VBA code, it appears to work, until I try to save the file and then I get the error.

In Excel I get no error message but when I close the file and then re-open it, the macro is no longer signed. In Word, the signature disappears when I save the file (no error message). In Outlook an error message appears when I try to save the VBA project “Microsoft Office Outlook. An error occurred while trying to sign the project. The unsigned project has been saved”

In Excel I get no error message but when I close the file and then re-open it, the macro is no longer signed. In Word, the signature disappears when I save the file (no error message). In Outlook an error message appears when I try to save the VBA project “Microsoft Office Outlook. An error occurred while trying to sign the project. The unsigned project has been saved”

Hi Stuart – I bought a code signing certificate from Comodo, but I could not make it work (altho I had no problem with Self Certificate) . Do you recommend the Thawte certificate?