+ Reply to Thread
Results 1 to 3 of 3

Pre-defined Folder in Save Dialog

  1. 08-05-2014, 03:59 PM #1
    Jonathan78
    Jonathan78 is offline
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Pre-defined Folder in Save Dialog

    The following code opens a dialog for the user to choose a folder to save the file as PDF.
    I'd like to set a pre-defined folder to start.
    Any ideas?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 08-05-2014, 04:03 PM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Pre-defined Folder in Save Dialog

    Try using ChDir and ChDrive at the start of the code.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 08-05-2014, 04:18 PM #3
    Jonathan78
    Jonathan78 is offline
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Pre-defined Folder in Save Dialog

    Thanks Norie, that worked!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Code to find a Folder name within a Parent folder that contains defined text
    By knowga in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-24-2014, 05:17 AM
  2. Auto save IE file download dialog box in a user defined path
    By sugaprasad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2014, 05:21 AM
  3. [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
  4. Save to folder defined by cell
    By alex3867 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2006, 04:24 AM
  5. Save file in a new folder, but create folder only if folder doesn't already exist?
    By nbaj2k in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-11-2006, 03:41 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1