Convert sheets to pdf. Filename and location path based on a cell

**Elainefish** · 03-27-2019, 03:08 PM

Hi,
I need macro that will Convert sheets to pdf in which Filename and location path are based on a cell.

Sheet names: UserPage and Summary_Print
Filename: UserPage!A1
Location: UserPage!A2

Thanks so much.

**davesexcel** · 03-27-2019, 03:13 PM

What part do you need help with? this question has been asked many times.

**jmac1947** · 03-28-2019, 01:55 AM

A great resource you should take the time to read and experiment with. Here is a link to a specific topic however the web site is full of helpful examples

http://www.rondebruin.nl/win/s5/pdf.htm

Cheers

Convert sheets to pdf. Filename and location path based on a cell

LinkBack

Thread Tools

Rate This Thread

Display

Convert sheets to pdf. Filename and location path based on a cell

Re: Convert sheets to pdf. Filename and location path based on a cell

Re: Convert sheets to pdf. Filename and location path based on a cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Save multiple sheets as one workbook, filename based on 2 cell values with current path

How do I get data from daily reports into a master document based on filename and location

Need to play a wav file based on path and filename in a selected cell using macro: SOLVED!

change path for save location based upon text in a cell

[SOLVED] Change file path name in VBA code based on files location

vlookup with variable for filename and path wants to append the filename after sheet name

Find filename, path, document size, filename length and path length?

Bookmarks

Bookmarks

Posting Permissions