Attach a file that is open to an email

[Bobbbo]

I have a macro that has the user browse for a file which I name "ManualForm" I do some edits to that file then I want to save it and email it as an attachment to an email. Here is the browsing code:

Please Login or Register  to view this content.

Then after my edits I use this code to attach it as an email but it fails, where "Cover" is another open workbook that contain information on where to: and cc: send the email.

Please Login or Register  to view this content.

Any idea why it will not attach the file?

[AlphaFrog]

The command .Attachments.Add is expecting a Path and File Name as string for an input argument. The function ManualForm is returning an Excel workbook object. They are two different things. One's an object, the other is a string. Does that make sense, or do you need more?

The quick fix it to change this...

Please Login or Register  to view this content.

To something like this...

Please Login or Register  to view this content.