X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Vba To Save As Pdf - Office 2016, Any Version    
post Nov 7 2019, 06:19 PM

Posts: 176
Joined: 28-August 10

I have written some vba within a workbook that unhides specific sheets and saves them as a single pdf. Everything works great, but I need to be able to Save as, and choose where to store the file and what to name it vs, having it go to a default folder and not be able to be named differently each time.
I found some code that should allow this using the Application.GetSaveAsFilename method, but I am so new at all of this, I am not sure how to integrate it into my existing code.
This post has been edited by ginmarie: Nov 7 2019, 06:20 PM
Attached File(s)
Attached File  My_TimeSheet.zip ( 152.2K )Number of downloads: 9
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    1st April 2020 - 07:05 PM