I posted this last night but due to the forum system being slow, it was posted multiple times violating a rule and all the posts were closed by an administrator.

All I am try to do is have macro that has the users browse for an excel file, then the code does some edits on that file than the code needs to attaches that file to an email and sends the email.

I am using this code to attach the file to the email:
.Attachments.Add ManualForm
Where "ManualForm" is the name of the file. humdingaling told me I have to add the full path for the file, but since I had the user browse for it, where would I get the path as the file could be located anywhere on the C drive.