Is it possible to save data entered in a userform to an external (unopened) excel file?

[mrapes]

I am currently trying to find a way to have data entered in a userform saved in an unopened excel file. At the moment I have the data going into a second sheet in the same file, but I would really like it saved in separate file. Is this possible? If so, how would I go about doing so?

[tigeravatar]

mrapes,

Assuming your userform has a Submit (or similar) button, it would look somthing like this:

Please Login or Register  to view this content.

[mrapes]

Thank you. I will have to try that. Also, do you know how to send an email with a range of cells included from that external excel file? This is what I have right now to pull from the current file.

Please Login or Register  to view this content.

[tigeravatar]

Not quite sure how you want it formatted, but here you go:

Please Login or Register  to view this content.

[mrapes]

The first set of code worked amazingly! Thank you so much. The second set (with regards to email) still pulls from my current excel file instead of the one that I placed the data in.

-Melanie

[tigeravatar]

Change this line:

Please Login or Register  to view this content.

To this instead:

Please Login or Register  to view this content.

[tigeravatar]

Just to note, you'll have to do that before the wbDest.Close line

[mrapes]

That won't work. Get run-time error '424' Object Required

[mrapes]

Sorry, I missed your last post. It still isn't working though. There error I get now is "Run-time error '-2147417848 (80010108)': Method 'MailEnvelope' of object '_Worksheet' failed"

[tigeravatar]

I am unable to duplicate that error. Can you post a sample file that is experiencing the issue?

[mrapes]

Here is the code I am using that gets the error.

[tigeravatar]

Using your attached workbook, I was able to save to the external file, create the message from the data that was written to it, and send the email with no errors, using this code:

Please Login or Register  to view this content.

[mrapes]

That works great! thank you so much!! Now how do I not have the button in email when I send it?

[tigeravatar]

I'm afraid that I'm not entirely certain what you mean. I think you can comment out (or delete) this line:

Please Login or Register  to view this content.

If that doesn't fix it, can you explain more what you mean?

[mrapes]

That did not do the trick. When I use the exact code that you sent me, it places the button that brings up the userform in my email.

[tigeravatar]

I do not get that issue using the code I provided, so I'm not sure what's causing that

[mrapes]

Ok. Well thank you very much. This problem really isn't that big of a deal. You solved most of my problems!

[lloydgodin]

I found this code works great for sending e-mail.

Please Login or Register  to view this content.