save as pdf in current path?

**bruizer31** · 07-01-2013, 02:55 PM

Hi all, Hoping someone can help me out with a little addition to my macro.

I currently have a macro that after running opens up a save as dialogue box so i can save the file in the specific folder i need to. Is there a way to add that filepath (after i have saved it somewhere) to a variable, so that it will save a pdf copy as well?(after i have saved it in the location i want to?)

Thanks for yalls help!

**humdingaling** · 07-02-2013, 01:26 AM

do you want the saveas dialogue or do you want set filename/path elsewhere in the code and not use the dialogue at all?

**humdingaling** · 07-02-2013, 01:40 AM

Heres code i use for my pdf/saveAs macro

Please Login or Register  to view this content.

**bruizer31** · 07-02-2013, 10:39 AM

I actually have the getsaveas dialogue pop up to save the excel file beforehand, so if it could just save a copy as a pdf that would work the best. Is that what your code does?

**bruizer31** · 07-02-2013, 10:46 AM

My current code seems to let me choose where to save it, then ask me if i want to save a pdf. BUT when i do save the pdf the excel file is no longer in the folder, only the pdf shows up. Any tips on how to get it to save where i specify as a excel file then save a pdf version as well?

Thanks for your help!

Please Login or Register  to view this content.

Also if there is a more efficient way to write this please let me know! Always looking to learn

**humdingaling** · 07-02-2013, 08:12 PM

does your pdf file actually work as pdf with your code?

saving as pdf and renaming file to .pdf is two different things...the later usually does not work in my experience
its like renaming a .jpg in .txt and hoping it reads in text file

also your getsaveasfilename
Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.

**bruizer31** · 07-02-2013, 08:14 PM

You're Correct. I learned shortly after posting it won't open

**humdingaling** · 07-02-2013, 09:07 PM

Please Login or Register  to view this content.

you have some variables i dont know what they are but i left them in there

ps
for saving pdf
pdfilename = myFileName does nothing
saving pdf just saves as what the workbook is saved as
ie if workbook is 03-07-02.xlsx then pdf is 03-07-02.pdf