+ Reply to Thread
Results 1 to 5 of 5

Find folder and save as PDF

  1. 02-13-2015, 09:02 AM #1
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Find folder and save as PDF

    Had a lot of help here on this and got the save as PDF working.If the folder exists it save the file like it should. Problem is when
    folder does not exists I get error. Had some help from another site on this but the code will find the folder?
    Thread is here http://www.ozgrid.com/forum/showthread.php?t=193150

    I think the problem is in the strFolder

    Please Login or Register  to view this content.
    Last edited by zplugger; 02-13-2015 at 09:56 PM.
    Reply With QuoteRegister To Reply
  2. 02-13-2015, 06:46 PM #2
    Blokeman
    Blokeman is offline
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    349

    Re: Find folder and save as PDF

    This will look at the whole directory structure.

    Please Login or Register  to view this content.
    Paste this in ThisWorkbook
    Please Login or Register  to view this content.
    Please click the * Add Reputation if this helps
    If solved remember to mark Thread as solved

    "I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."
    Reply With QuoteRegister To Reply
  3. 02-13-2015, 08:33 PM #3
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Find folder and save as PDF

    Thanks Blokeman
    Getting error on range?

    Error.JPG
    Reply With QuoteRegister To Reply
  4. 02-13-2015, 08:44 PM #4
    Blokeman
    Blokeman is offline
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    349

    Re: Find folder and save as PDF

    Sorry I forgot this Function;
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-13-2015, 09:56 PM #5
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Find folder and save as PDF

    That's better Thank for your Great help.
    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] Lookup folder from cell text, then save excel file in this folder
    By dodgybob in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2014, 09:00 AM
  2. [SOLVED] VBA to save a workbook to a folder but create that folder if it doesn't already exist
    By cnixon in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-24-2014, 06:01 PM
  3. Code to create New Folder (if doesn't exist) and then Save Workbook to folder
    By jenhawley in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-10-2013, 03:09 PM
  4. [SOLVED] Create a new folder based on a cell name or value and save copy onto that folder
    By Le_Tiago in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-20-2012, 01:33 PM
  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