ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Digital signatures in Excel (https://www.excelbanter.com/excel-worksheet-functions/124310-digital-signatures-excel.html)

Santi

Digital signatures in Excel
 


Hi,
I am looking for information to apply digital signatures to a .xls
document from VB. I saw how to do it in a Word document:

Set wordapp = CreateObject("Word.Application")
Set worddoc = wordapp.Documents.Open(docu)
wordapp.Visible = True
Set sig = worddoc.Signatures.Add

In Excel it must be similar using Excel objects instead of Word, but it
fails. Can anybody help me?

Thanks




Bob Phillips

Digital signatures in Excel
 
See
http://www.vbaexpress.com/forum/show...t=self+certify

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Santi" wrote in message
...


Hi,
I am looking for information to apply digital signatures to a .xls
document from VB. I saw how to do it in a Word document:

Set wordapp = CreateObject("Word.Application")
Set worddoc = wordapp.Documents.Open(docu)
wordapp.Visible = True
Set sig = worddoc.Signatures.Add

In Excel it must be similar using Excel objects instead of Word, but it
fails. Can anybody help me?

Thanks






Santi

Digital signatures in Excel
 
Thanks, but that nos is what I was looking for. In that article, it explains
how to avoid the security warnings, but it doesn't talk about adding the
digital signature from VB.
Thanks anyway. :-(



"Bob Phillips" escribió en el mensaje
...
See
http://www.vbaexpress.com/forum/show...t=self+certify

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Santi" wrote in message
...


Hi,
I am looking for information to apply digital signatures to a .xls
document from VB. I saw how to do it in a Word document:

Set wordapp = CreateObject("Word.Application")
Set worddoc = wordapp.Documents.Open(docu)
wordapp.Visible = True
Set sig = worddoc.Signatures.Add

In Excel it must be similar using Excel objects instead of Word, but it
fails. Can anybody help me?

Thanks









All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com