+ Reply to Thread
Results 1 to 1 of 1

Help adjusting macro that matches filename/exports file as PDF with filename

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Help adjusting macro that matches filename/exports file as PDF with filename

    My format recently changed resulting in all kinds of fun figuring out how to readjust my macros. This macro will look at A2, then look through the worksheets and find the matching sheet and save that sheet as a PDF with the filename. However, A2 will always just save the activesheet that has the list of all filenames. I've attached a workbook. The "Notes" sheet has three filenames. If you run this code then it should take the # out of the filename, match it to a sheet and export it. Instead, whatever is in A2 will save the "Notes" sheet as that filename. So A2 never is saved correctly. How do I exclude that sheet?


    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Formula to return filename in folder based on partial filename
    By Rerock in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-26-2014, 12:28 PM
  2. change filename to sequence filename with macro
    By ronexcel05 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2013, 04:27 AM
  3. [SOLVED] Find if filename exists and update variable within the filename structure
    By Lungfish in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-18-2013, 02:42 AM
  4. Macro: Open file but the filename changes
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2013, 06:36 AM
  5. Replies: 0
    Last Post: 11-01-2012, 09:28 AM
  6. Macro to copy from xls( variable filename) to static xls filename
    By gsp77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 09:33 AM
  7. Replies: 3
    Last Post: 07-09-2012, 03:09 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