populating a workbook but not opening it



Hi All, I have designed a button "Submit" on excel userform to email the
userform inputs to me.

What is happening is: Once I click "Submit" it opens the new workbook(where
I am saving the userinputs) , saves it.. and them mails it.. and this is
working great!

What I want is: Is there a way I can do this process without the new
workbook opening? I dont want it to open, save and mail.. I just want it to
save it and mail it..

Hope I made it clear

Thanks in Advance


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question