Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel sheet to PDF Macro = security question
All,
I found this piece of code on the group: Sub PrintPDF() Dim PSFileName As String Dim PDFFileName As String PSFileName = "D:\MyDoc.PS" PDFFileName = "D:\MyDoc.pdf" ' Print the Excel range to the postscript file Dim MySheet As Worksheet Set MySheet = ActiveSheet MySheet.PrintOut copies:=1, preview:=False, _ ActivePrinter:="Acrobat Distiller", printtofile:=True, collate:=True, _ prtofilename:=PSFileName ' Convert the postscript file to .pdf Dim myPDF As PdfDistiller Set myPDF = New PdfDistiller myPDF.FileToPDF PSFileName, PDFFileName, "" End Sub This runs fine under Admin permissions. BUt does not under a users. I have granted full read / write access to the folder where Adobe sits, but with no luck. Can someone tell me how the distiller works and what permissions the user would need to execute this? Doug |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 question - Macro Security | Excel Discussion (Misc queries) | |||
Very Novice Excel user with security question | Excel Discussion (Misc queries) | |||
How turn off macro security question for workbook with no marcos? | Excel Discussion (Misc queries) | |||
Macro security question | Excel Programming | |||
I got an Excel Macro/Security question that is driving me nuts..... | Excel Programming |