+ Reply to Thread
Results 1 to 2 of 2

Looping macro to save active sheet as PDF with specific name

  1. #1
    Registered User
    Join Date
    08-17-2017
    Location
    Minneapolis
    MS-Off Ver
    2013
    Posts
    1

    Looping macro to save active sheet as PDF with specific name

    Hi,

    I'm trying to get my looping macro to save as PDF using a specific cell (which changes every loop) as naming convention. The loop pulls data in from the "Master" tab. I want the name to save as cell "G3" on the main sheet. I can't figure out why it isn't working... can anyone help?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Looping macro to save active sheet as PDF with specific name

    g3 remains the same value every loop?

    what is the filename meant to do?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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 copy active sheet and save as csv format
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2016, 02:16 PM
  2. [SOLVED] Help with macro to text out Active sheet and sort data in specific column
    By Pi* in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-18-2015, 10:18 PM
  3. [SOLVED] History of save process in specific sheet for the active workbook
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2015, 04:39 AM
  4. vba to print active sheet to pdf, auto save in specific folder then mail using outlook
    By lathamashly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2014, 04:57 AM
  5. [SOLVED] save active sheet in new workbook, naming it as cell value of active sheet
    By arkharova.s in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2014, 06:16 AM
  6. MACRO save active sheet wth name from selected cell and without macros and buttons
    By forfiett in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-26-2013, 04:14 PM
  7. [SOLVED] How to get (range)macro to always run code on a specific sheet regardless of active sheet?
    By JTwrk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2012, 04:33 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