How To Close A Word Sheet From Excel Using VBA

[Maury1704]

Good day everyone my name is Maurizio and my problem is this.
I state that I use Microsoft Office Excel of 2007
Having said this I start by saying that: On an Excel sheet I would like to put some data that I will then need to be taken back as Attachments when sending E-mail.
But since I need to send formats of various kinds; I am forced to find a way to Create and Save this Data both in Format (Doc) and in that (Xls) and also in the classic (PDF)
Now: As for the Format (Pdf) I managed to create it and make it go inside my Subfolder called (Attachments)
Now what I would like to get the same from (Word) sheet
And also in this case I managed to create everything; Except that I can't Automatically Save it to my Subfolder
But I have to do it manually and I don't like it.
Ib more I ask you if you kindly could also help me with the format (Xls) Thanks
Greetings from A.Maurizio

 

[Fluff]

Duplicate to: How To Close A Word Sheet From Excel Using VBA

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.