I have about 100 excel workbooks each month that contain a Signature Line. Each workbook requires me to open, click on the signature line, select sign, select image, and final click on the sign button.
Does anyone know if it is possible to build a macro that can do the steps above? I'm thinking I could script a loop to open each workbook, perform the signing steps, and close. I tried recording the steps while signing, needless to say that didn't help much.
Thanks,
Jamie
What exactly do you mean by 'Signature Line'?
There are many examples of processing multiple workbooks from a folder but we need more information about the signing process.
Sorry... I forgot that there are many ways to sign. I'm using Excel 2007. On the Insert tab, on the far right there is an icon for Signature Line. When selected, there are two options: Microsoft Signature Line or Add Signature Service. By selecting Microsoft Signature Line, a signature line object can be place on the worksheet. When the Signature Line object is selected, then right click, the option of signing is available.
Jamie
Last edited by JDavis; 05-29-2009 at 10:06 AM.
There does appear to be objects within the application to do with signatures.
But it simple displays the dialog. Perhaps if you have know signatures you can use that to bypass the dialog.
macro recorder gave this.
ActiveWorkbook.Signatures.AddSignatureLine "{00000000-0000-0000-0000-000000000000}"
Thanks for the help... I will keep digging.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks