Print/Save to .pdf using a Macro that references a range/cell

**WithinTheLight** · 02-22-2018, 04:14 PM

Hello,

I am attempting to use an Excel Macro to print/save a file that has its file directory in a cell, in this case B3. Is this possible, as I have spent hours searching for a solution or help on how to do it but have had no luck. Basically, you click the button to the right of it and then prints the file is in the cell. See picture below. I use Excel 2013. If possible, please help or link me to any useful guides.
Capture.PNG

Thank you

edit:
I want to print/save to pdf the file that has it's directory in the cell off of this sheet. I have to deal with sending out dozens of excel files that I have to manually print/save to pdf and it is very time consuming.

**ranman256** · 02-23-2018, 08:25 AM

vFile = range("B3").value & ".pdf"

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
vFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= False

**WithinTheLight** · 02-23-2018, 10:28 AM

Originally Posted by ranman256

vFile = range("B3").value & ".pdf"

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
vFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= False

Unfortunately it did not work. It still prints out the active sheet. What I am trying to achieve is that when you click the button, it will print the file in the range. Not print the current worksheet as that files name.

**ranman256** · 02-28-2018, 08:46 AM

set print area, then print.

Print/Save to .pdf using a Macro that references a range/cell

LinkBack

Thread Tools

Rate This Thread

Display

Print/Save to .pdf using a Macro that references a range/cell

Re: Print/Save to .pdf using a Macro that references a range/cell

Re: Print/Save to .pdf using a Macro that references a range/cell

Re: Print/Save to .pdf using a Macro that references a range/cell

Thread Information

Users Browsing this Thread

Similar Threads

Macro, to Set Print Area, Save as, Print

[SOLVED] Run a macro before you save or print off

[SOLVED] Save/Print Macro

where can i find macro codes for various functions such print, save and save as

Print only visible rows and a print to or save as pdf Macro

save as and print options macro

Recording Macro to save worksheet and print

Bookmarks

Bookmarks

Posting Permissions