Export as PDF (with specific file name) not working

[namialus]

Hi all,

I have this code (not sure from which thread) which
can export my worksheet with specific file name & folder
(according to date and part type). I tried to put
it in my worksheet but it's not working.

Please Login or Register  to view this content.

and it's highlighted at following part

Please Login or Register  to view this content.

I received this error from the message box
Run-time error '1004'

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

Really appreciate your help.

Thank you in advance

[ragulduy]

Can you save the file as a pdf with that folder path/filename manually?

[namialus]

Dear ragulduy,

Sorry the formula works well actually & I found my mistake :
The macro can't find the actual file directory because I moved this macro file
to a different folder.

Thank you anyway for your quick feedback

[namialus]

Dear ragulduy,

Sorry to trouble you, actually I need to change the folder :

Please Login or Register  to view this content.

to same folder as the workbook (need to change the first E:\Test| folder to "Summary" folder

Thank you in advance

[namialus]

Dear ragulduy,

Sorry to trouble you, actually I need to change the folder :

Please Login or Register  to view this content.

to same folder as the workbook (need to change the first E:\Test| folder to "Summary" folder

Thank you in advance

[ragulduy]

Please Login or Register  to view this content.

will give you the name of the folder the activeworkbook is saved in (although you may need to add an additional \ to the end.

[namialus]

Thank you for your guide ragulduy,

I also need the macro to create the folder if the folder not yet been created, is it possible to combine
with present script ?

Please Login or Register  to view this content.

Thank you in advance

[ragulduy]

This will create the folder if it does not already exist:

Please Login or Register  to view this content.

[namialus]

Sorry ragulduy,

I'm still learning this vba script, where should I put the script
in my present code?

Thank you in advance

[ragulduy]

Please Login or Register  to view this content.

I'd probably do it like that.

[namialus]

Dear ragulduy,

I received syntax error & it's highlighted at :

Please Login or Register  to view this content.

[ragulduy]

Oops sorry, remove the dim before fso, that line should be

Please Login or Register  to view this content.

[namialus]

Dear ragulduy,

Thank you for your reply.

Received error message box :
Runtime error : 1004

with highlight on :

Please Login or Register  to view this content.

Thank you in advance

[ragulduy]

What is the value of foldername at that point?

[namialus]

Dear ragulduy,

Sorry for late reply,

I don't understand :

What is the value of foldername at that point?

Is it the name of the folder, if it is , the folder name consists of two
phrases (eg: new record) and usually it's text only (without numbers or character)