Autoname .PDF conversion to the name of the .xlsb from which it came

[jonvanwyk]

I have a macro (see code below) that automatically converts the print area of the a worksheet into a pdf file, and then automatically saves the PDF into a specified location, and finally saves the portion of the excel file that affected the print area.

Right now I have to specifically name "filename" whatever I want the PDF to be saved as. Since I have to replicate my workbook several times, it would be very convenient if the code could autoname the PDF with the same name as the .xlsb file from which it was made. For instance, if the excel file's name is "Doe, John.xlsb", then the code auto saves the PDf as "Doe,John.pdf" when that macro is clicked. This would save a tremendous amount of time of renaming "filename" for 80 people for 26 pay cycles (2080 times!).

Please Login or Register  to view this content.

[cheddarthief]

I have a macro that someone a long time ago wrote for me that takes every "active" tab, makes a copy of that worksheet in that specific tab, saves that file to match the name on the tab as it's own specific file, emails it to the person identified in that file, then deletes the file from the memory.

Obviously this is more than what you want but maybe you can take the pieces of the code and adapt it to work with your macro. I personally do not write code but I can follow along with it. Below is the code and as I said you may be able to Frankenstein something together. Hopefully it works. Good luck:

Please Login or Register  to view this content.

[jonvanwyk]

I specifically need to have the .pdf file autonamed to match the name of the .xlsb file from which it was created. cheddartheif's code needs too much modification to be able to use it (at least for me to modify).

Anyone else have any ideas?

[royUK]

This might work

Please Login or Register  to view this content.

I'm not sure what this is

FY2012\27 = 061712 - 063012

[jonvanwyk]

@royUK

That worked perfectly. You have no idea how much work you just saved me!

Thanks!