VBA to Save as with variable string name

[EverBalzing]

Appreciate any help in advance.

I have a VBA code below that finds a specific text and then copies the numbers next to it in Microsoft Word. where it is failing which i'd need help with is saving the current opened document as PDF using the string name. I receive a runtime error: This is not a valid Filename

Please Login or Register  to view this content.

appreciate any help.
Lucas

[6StringJazzer]

What are the values of strPath & myNum when the error occurs?

There are several places a problem could be introduced here but it's not possible to diagnose without knowing what you expect this code to do and also sample data to see if the code is correct.

[EverBalzing]

Thank you for your reply Jeff.

I've exchanged the code to save as below.

myNum is a number always, example is 111 111 111

When I do msgbox myNum I get 111 111 111

when I change the value Mynum to below it saves it as Test_File and works fine. so it must be some formatting with myNum as there maybe an enter or extra space.

MSGBOX.gif
myNum.gif

[6StringJazzer]

Is it possible that myNum contains a non-printing character? I would do this:

Please Login or Register  to view this content.

Then show us what prints in the Immediate window.

[EverBalzing]

Attachment 733267

Thank you for your reply. Please find above attached screenshot.

[6StringJazzer]

The final character is a carriage return character, not valid in a file name. I can't figure out your logic for assigning myNum so it's hard for me to tell you how to fix it. The brute force method would be to add this line of code after setting myNum:

Please Login or Register  to view this content.