How to change name of attachment to mail, sent through excel

I have made a form in excel, made up of some checkboxes en textboxes. I have managed to create a button which will create and send the entire excel file as an attachment to a certain emailadres. I have also (will help from this forum) added the creationdate en time to the saved and attached file.

I would however like to add the content from 2 textboxes to the name of the attachment. For example, a name and an organisation should be filled in in the textboxes. I would like the attachement to contain these names. I cannot find the way to add this. Can anyone please point me in the right direction.

I also have an additional question. The textboxes have to be clicked before one is able to enter the text. Taborder is greyed out. How can I give these textboxes (and checkboxes) a certain order so you can tab or enter through them?

thanks in advance!

gr,
Lance

I have found out how to insert the text into the attachment, as it was quite simple. It probably needed me to ask somebody else before all of a sudden I got it.

I just had to insert TextBox1.Value & TextBox....... etc into the tempfilename.

This stil leaves my question about the tabbing through textboxes. Hopefully this will come to me aswell.

The Tab issue also finally came to me. I added textbox1_keydown ... and made a manual loop.

Thanks anyway.

This thread can be closed, if I can close it myself somebody please let me know.