It's probably that the string that I am using to generate the path and filename is not exactly the same as on your system.

"C:\Documents and Settings\carl.walker\My Documents\Machine DWG\" & Cell.Value & ".pdf"
If your replace Cell.Value with the number - does this give the correct path?