Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
populating a workbook but not opening it
Look at Ron's site. If you don't find the answer there, it probably is not
practical to do. http://www.rondebruin.nl/sendmail.htm "sam" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating Excel Web Query across workbook | Excel Discussion (Misc queries) | |||
excel VBA problem - setting workbook as variable & opening/re-opening | Excel Programming | |||
VBA for opening file/populating combo box with sheet names | Excel Programming | |||
How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
How to make opening of workbook conditional of opening of another workbook | Excel Programming |