Save PDF with Dynamic destination folder

[Designernadir]

Hello Everyone,

I am a new entrent to this forum and this is my first post. And I am not at all an excel expert but keen to use excel to its best possible way.
Can anyone help me ....
I have created a macro button to save my excel cell range (A1:H42), which is basically a invoice in pdf format in the folder which I have put in as a path. While saving the file the macro saves the invoice with a filename taking the cell Value from (G8).
Is it possible if I put a different folder name in (G8) everytime I create a new Invoice and when I press the macro button to save the file , then it searches for the same folder automatically in my computer and saves it there? Please help.

Regards
Designernadir

 

[DanteAmor]

Re: How to save PDF with Dynamic destination folder

Hi

What do you have in cell G8? LE MARAIS101 FZE

Regards

That means that this folder does not exist:

E:\[COLOR=#ff0000][/COLOR]My Documents\Armoplast\Armoplast Customer DIR\[COLOR=#ff0000]LE MARAIS101 FZE\[/COLOR]

You must first create it.