+ Reply to Thread
Results 1 to 1 of 1

Set standard path to save .pdf

  1. #1
    Registered User
    Join Date
    07-02-2018
    Location
    Drunen
    MS-Off Ver
    2013
    Posts
    60

    Set standard path to save .pdf

    Hi,

    I`m using the following code (from rondebruin) to create multiple PDF files depending on different variables.

    Please Login or Register  to view this content.
    Now i have a different macro with the line .InitialFileName = "L:\Kevin" so that the filedialog is set standard at this path, however i cant find where to put this in the above code.

    EDIT, crap overlooked this : Fname = Application.GetSaveAsFilename("", filefilter:=FileFormatstr, _
    Title:="Create PDF")
    So i put the path whitin the Application.GetSaveAsFilename("") , Fixed.
    Last edited by MrMyagiii; 08-10-2018 at 02:55 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to save file by employee and save as PDF in path
    By jw01 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-18-2017, 11:39 AM
  2. [SOLVED] Correct save path and syntax to save workbookdirectly into ONEDRIVE subfolder
    By osbertdebroilg in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-29-2015, 06:27 PM
  3. Save the open sheet in a path with a save as dialogue box and also create two folders
    By Biplab1985 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2015, 05:19 PM
  4. [SOLVED] Make another copy and save in diffrent path when i apply save
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-16-2014, 09:00 AM
  5. how to specify a file save path to a save macro
    By Solidstan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-04-2013, 05:33 PM
  6. [SOLVED] Save As Dialog Box - Default Path and File Name, User Selects Sub Folder from Default Path
    By christenprochaska in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 05:17 PM
  7. How can I save a customized Standard toolbar?
    By TD in forum Excel General
    Replies: 1
    Last Post: 03-25-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1