Results 1 to 16 of 16

VBA that saves filename with name that is same as the directory it is placed in

Threaded View

  1. #16
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: VBA that saves filename with name that is same as the directory it is placed in

    What does the following line of code mean?
    If you pressed the button to proceed then .Show returns -1, if you canceled I believe it equals 0.
    So if you canceled it jumps to the NextCode: line and exits.

    Also what data type is FileDialog? I don't think I've seen this before:
    Did you read the code?
    Set fdp = Application.FileDialog(msoFileDialogFolderPicker)
    If you are happy with my help feel free to press the add reputation button at the bottom left of this post.

    If all is good.
    Please click the Thread Tools drop down box above your first post and choose solved.
    Last edited by skywriter; 09-15-2015 at 09:01 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. HELP VBA code which saves each worksheet tab as a PDF in a specific directory
    By vba_newbie83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2014, 06:28 AM
  2. Replies: 1
    Last Post: 09-26-2012, 09:37 AM
  3. VBA Macro that converts and saves the worksheet into a PDF & customizing the filename
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-28-2011, 03:17 PM
  4. Macro Saves to Incorrect Directory
    By kirsty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2011, 02:19 PM
  5. Excel 97 saves one digit filename
    By Flyeral in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 12-12-2007, 03:39 PM
  6. Create buttom that saves current file in a given filename (Excel)
    By mamealemka in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-17-2006, 08:10 AM
  7. Routine that saves a file. If more than 7 in directory, deletes the oldest.
    By wayliff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2005, 11:20 AM

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