MACRO - Save Filename & Location based on Cell value

[acerlaptop]

Hi everyone.

I have a code here that I've been working on. The problem here is that it always end up in ERROR.

Here's the code:

Please Login or Register  to view this content.

Hope you can help me.

[davesexcel]

what line errors and what is the error?

[acerlaptop]

what line errors and what is the error?

It Says

Run-time error '1004':

Document not saved. The document may be open, or an error may have been encountered when saving.

Then it highlighted:

Please Login or Register  to view this content.

It only happened after I added

Please Login or Register  to view this content.

on "SaveTo"

[davesexcel]

What is in B20?

Do you have the PDF opened when running the code?

[acerlaptop]

What is in B20?

Do you have the PDF opened when running the code?

B20 is a cell that contains values (letters) I want to include in the file location.

If the value of B20 is "ABCD", then the save location would be H:\TEST\ABCD\

PDF is closed while running the macro.