Increase cell by 1, print as PDF and save PDF with that cell number as file name

**eldred100** · 08-13-2012, 08:24 AM

Hello,

I am making a PDF page-per-day diary and it is my first foray into macros. Rather than sitting here re-typing the date 364 times I am hoping someone can help me

I would like a button or a shortcut that increases the cell number (cell is D4) by 1, then print as a PDF, then save as a PDF with the value of D4 as the filename.

Is this possible?

Thank you

Anna

**TMS** · 08-13-2012, 08:49 AM

If you have a PDF printer installed, something like:

Please Login or Register  to view this content.

Regards, TMS

**eldred100** · 08-13-2012, 08:59 AM

Thank you!

That works great for updating the date and printing as PDF.

Is there any way to make it save the PDF by the value in D4 or do I have to do that manually?

Thanks again

Anna

**TMS** · 08-13-2012, 09:39 AM

Hi Anna

you need to use Save As ... PDF file

the code is:

Please Login or Register  to view this content.

You'd need to change the file name to include the date. However, you'll need to format the date so that it doesn't have the slashes in it.

So you'd use the value in D4 but you'd format it (maybe using TEXT) as "ddmmyyyy"

Please Login or Register  to view this content.

So, you just have to hang those bits of code together ...

Regards, TMS

Increase cell by 1, print as PDF and save PDF with that cell number as file name

LinkBack

Thread Tools

Rate This Thread

Display

Increase cell by 1, print as PDF and save PDF with that cell number as file name

Re: Increase cell by 1, print as PDF and save PDF with that cell number as file name

Re: Increase cell by 1, print as PDF and save PDF with that cell number as file name

Re: Increase cell by 1, print as PDF and save PDF with that cell number as file name

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions