populating a workbook but not opening it

S

sam

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

Similar Threads

Store input from userform in a password protected sheet 3
email only current entry, not the past data 3
Export user inputs to a template and save it as a different file 1
Save workbook button on Userform 2
email issue: need last user input only 18
Display File path as hyperlink in outlook 2
save user inputs from userform in a seperate workbook 6
closing another file by code causes failure to run workbook activate event 2

Top