Macro Certificates with Enterprise Server

Microsoft OFFICE


  • 1. compatability
    I have written a program in VBA 6.0 (office 2000, Windows XP). THis program works well on the system I have written it, but gives debugging error on another system(office 2000, Windows XP). It is also displaying different interfaces on Window XP OS with Office XP on it. Can someone help me with this problem?
  • 2. Word 2003 Mail Merge to Outlook 2003 Contacts...
    In past versions of Word, you could use the ActiveDocument.MailMerge.UseAddressBook Type:="olk" statement to retrieve and merge a users contacts into a Word mail merge document. The UseAddressBook statement is no longer supported in Word 2003. There are many examples of VBA Mail Merge connection strings to databases, word documents, excel spreadsheets - but not one example which provides the recommended method for VBA to do a Word 2003 mail merge to Outlook 2003 contacts. Could you help me with the correct VBA syntax for defining the data source or connection string for Outlook 2003 Contacts? Thank you.
  • 3. Outlook "Save as" .MSG is not truly repeatable
    Hi all, my issue pertains to Outlook 2000. When I open an Outlook item, save it as a .MSG file (say 1.MSG), and then repeat the save to another file name (say 2.MSG) the 2 files are NOT identical. The differences are not visible to the user who compares 1.MSG and 2.MSG with the Outlook UI, but a comparison of the files at the byte level yields several variances. What makes the files different? Is there any documentation on the .MSG format which might enable me to understand, predict, and redact the variable portions of the message? Thanks for your time.
  • 4. Opening IE with VBA
    I store a large HTML string in a table and would like to be able to open Internet Explorer with the html by clicking a button on a form. I can do everything in VBA but open IE with the HTML. The optimal solution would be to pass in the string when opening IE so that it is clean and easy. Does anyone have any code that will open IE from within VBA? I am using Access 2000 and IE 6. Secondly, I have recently learned to code html and love the possibility of creating reports in html, from VBA code, and opening them in IE; sorry but Access reports are not by favorite feature. Can someone recommend a website that has examples of code that accomplishes this goal? The possibilites for html reporting are endless since you can control the entire look of the page. Plus you can pass in vbscript and gain even more control and functionality. Thanks in advance!!!

Macro Certificates with Enterprise Server

Postby News Users » Fri, 14 May 2004 16:24:16 GMT

Does anyone know if I can use a Windows certificate server to sign macros in

It seams I can self certificate and also that I can use third party internet
based certificates but I cant see how to do it with our own internal AD
Enterprise certificate server. Is it possible??



Re: Macro Certificates with Enterprise Server

Postby Mike Walker » Sun, 16 May 2004 08:01:46 GMT

You can create a certificate of Code 3 Codesigning certificate type that you
could issue and this would be compatible as long as it is based on this


Mike Walker
(Reply via NG)


Similar Threads:

1.Creating Server Certificate for Excel Macros

I think this is an easy problem to solve but I have not had any luck
finding the solution. I have created an Excel Template that contains a
macro. I would like to assign the macro a certificate from the Windows
Server 2003 Certificate Server. I have reviewed the templates on the
Cert Server and none seem to be applicable to a VBA script. Where can
I find some detailed instructions on how to create a certificate on my
network server then apply it to my Excel Template for the rest of the
organization to use?


2.Install certificate, enable macros with signed certificate

How can you install a certificate, then allow all templates that are
signed with that certificate to be trusted to run macros?

I can do it by installing the certificate first, reducing the security
settings to Medium then when loading the signed template enabling

However, this is just for the currently logged in user. I wish to do
this for all users.

Can this be done via the command prompt? I assume you can use certmgr,
with the .cer file as a parameter, but how do you do it so it installs
for the all users (i.e. Local Computer) and then set it up so that
anyone who logs in can run macros (without resorting to reducing
security settings and then enabling macros)?

Would like to do this via batch file, using RunAs if not logged in as

3.SQL Server data cube / digital certificate / macro paste issues

I hope that someone here can help with the following:

A customer has a spreadsheet which holds a pivot table that links to a SQL 
Server Analysis services data cube. The spreadsheet contains macros which 
format the pivot table & pivot chart according to some preset charts.  It is 
sensitive data and therefore has restricted access. It is published on their 
intranet, so apart from maintenance users, is accessed via Internet Explorer. 

Last week they had a problem trying to access this spreadsheet over Citrix, 
because user's default security settings were high - and that only enabled 
them to run macros which were signed. So they purchased a digital signature, 
installed it on a machine, and signed the spreadsheet macros. The spreadsheet 
now runs OK on Citrix, users only have to say they trust macros signed by us, 
and almost all works OK.

Until this morning, the customer discovered a very worrying set of symptoms 
with the spreadsheet. It happens when the visible chart is selected, copied 
to clipboard, and pasted into Microsoft Powerpoint. My customer has a macro 
function which selects the visible chart and copies to clipboard, and this 
shows exactly the same symptoms as doing it by hand.  Pasting into Microsoft 
Word does not seem to be a problem.

The Errors are:

1: On opening the published version, running a chart, selecting "Copy to 
clipboard", when pasting to PowerPoint, error message "Macros do not match 
digital signature - this can only happen with a macro virus - macros will be 
disabled" error message comes up. Select OK and the picture is visible, 
though. Also get other "Error accessing file" messages (as in 2). This 
happens only if Powerpoint window opened after the copy; if opened before, 
they get error 2.

2: Get "Error accessing file" when pasting chart. Does not happen on Word 
paste, only PowerPoint; happens 7 times then picture is pasted. Does not 
happen on repeat try.  For variant 2 of this error 

3:  On pasting chart into another application, customer gets "An application 
is requesting access to Private Item - CryptoAPI Private key". This also 
appeared on anothe user's machine. Only seen with Powerpoint paste; never 
appeared on Word paste. Seen this several times but not sure what 
circumstances cause it to appear.

4: After error 3 get "The server application cannot be found" 

4.Automatic certificate enrollment for ISA Server Certificate failed

5.Can I install SQL Server 2000 Enterprise Edition and SQL Sever 2005 Enterprise Edition on Windows 2003 Server Enterprise R2?

Dear All,

I first tried installing SQL server 2005 enterprise edition in windows 2003 
enterprise server R2. I quited it half-way (Before custom selection of 
components) and installed SQL server 2000 enterprise edition. This installed 
successfully. Then when I tried installing SQL server 2005 enterprise 
edition, it is giving me the following error in one of its log file.

Product: Microsoft SQL Server 2005 -- Error 2331. The installer has 
encountered an unexpected error. The error code is 2331. Error loading 
library C:\Program Files\Microsoft SQL Server\90\Setup 
Bootstrap\Bin\{58233A5F-5CE3-4EEE-BB9E-E0910E005E15}sqlca.dll or finding 
entry point The specified module could not be found.

After this I uninstalled SQL server 2000 and installed sql server 2005. This 
time also I am getting the same error.

Can any one help me out in this?

Thanks and Regards,


6. Migrating from Pervasive SQL server to SQL server Enterprise edition

7. Blackberry Enterprise/ Outlook Web Access 2007 - prevent certificate signing

8. Macro designed to send mails via Outlook : question on certificate

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 70 guest