Does anyone know if I can use a Windows certificate server to sign macros in office. 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 based Enterprise certificate server. Is it possible?? Thanks Tim
Macro Certificates with Enterprise Server
2 posts
• Page 1 of 1
- 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!!!
Next
Macro Certificates with Enterprise Server
by News Users » Fri, 14 May 2004 16:24:16 GMT
Re: Macro Certificates with Enterprise Server
by 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 template Rgds Mike Walker (Reply via NG) in internet
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? Alex XXXX@XXXXX.COM
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 macros. 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 admin.
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
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,
Peri
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
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 70 guest