ExportAsFixedFormat?
I have the following linked to a button and currently works great:
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\Users\Robby\Desktop\Report Test2.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True Is there a way that I can either specify a cell location for the filename property or open a folder dialog box allowing the user to specify? Thanks all! |
ExportAsFixedFormat?
Hi Robby
See http://www.rondebruin.nl/pdf.htm Change FilenameStr = Application.DefaultFilePath & "\" & _ Format(Now, "dd-mmm-yy h-mm-ss") & ".pdf" To FilenameStr = Range("A1").Value -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Robby" wrote in message ... I have the following linked to a button and currently works great: ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\Users\Robby\Desktop\Report Test2.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True Is there a way that I can either specify a cell location for the filename property or open a folder dialog box allowing the user to specify? Thanks all! |
ExportAsFixedFormat?
Ron,
This works GREAT! Thanks much for the suggestion! "Ron de Bruin" wrote: Hi Robby See http://www.rondebruin.nl/pdf.htm Change FilenameStr = Application.DefaultFilePath & "\" & _ Format(Now, "dd-mmm-yy h-mm-ss") & ".pdf" To FilenameStr = Range("A1").Value -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Robby" wrote in message ... I have the following linked to a button and currently works great: ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\Users\Robby\Desktop\Report Test2.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True Is there a way that I can either specify a cell location for the filename property or open a folder dialog box allowing the user to specify? Thanks all! |
ExportAsFixedFormat?
Hi in order .ExportAsFixedFormat to work we should must define anything in
the definition? What exactly ?? "Robby" wrote: I have the following linked to a button and currently works great: ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\Users\Robby\Desktop\Report Test2.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True Is there a way that I can either specify a cell location for the filename property or open a folder dialog box allowing the user to specify? Thanks all! |
All times are GMT +1. The time now is 07:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com