This is part of another thread I have,but this is a different problem.So here we go,when the sample workbook has vbaproject password and you click the commandbutton Outlook
will open behind the workbook.If there is no vbaproject password then Outlook will open on top of workbook?. Any ideas on what or where I should go to fix problem.Looking for any suggestion on this,tried on different computer with Excel 2007 and same problem,I'm running office 2013 32 bit.
Password 1234
Thank You
Last edited by zplugger; 08-25-2015 at 05:20 PM.
It's working fine for me in either configuration.
PC - Excel 2010 Win7 32bit.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Just tried it with Windows 7 64 bit, Excel 2007 32-bit. Works fine with, or without a password. In both cases, it loads the Outlook window in front of the Excel window.
No help but maybe it narrows down the possibilities.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks to both of you guys for trying,not sure why I have problem after VBAProject password is set. I install office 2013 on my labtop today and the same things happens.This
one is driving nuts,so lost on what to try now.Going to friends house and try on his computer now,if it works I well really be lost.LOL Will post on what happens.
Good luck!
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
You're welcome. Thanks for the rep.
I guess that it's starting to point to Office 2013, or maybe a configuration option. Unfortunately, I can't offer any further help.
Regards, TMS
Ditto thatYou're welcome. Thanks for the rep.
and that.Good luck!
Well just got back home,friends computer running office 2007.No mater what I did on his computer it open behind the workbook.???????? This even makes me more lost,is ther a way to set focus on the inbox to open? Why is excel so different on every computer.
Z
It's not. It's just your computer.Why is excel so different on every computer.
That's how I feel when no one else can replicate a problem I'm having.
I think the OP has now tried it on 3 different computers with 2 versions of excel and is getting the same result on each one, which is not the result that the 3 of us are getting. I think the problem is........., I don't' know! It has had me baffled for days.
With you gmr4evr1,all this does not make since.
z
Tried a dozen codes for opening outlook and sending mail,they all work.But put a vbaproject password on them they all open outlook behind workbook.I do not understand why the password would
cause this.Different people try the example workbook and works perfect with or without password.Tried example on laptop with new excel install and have same problems,All ideas are welcome on
a possible fix to this. My computer is windows7 64 bit running 32 bit office2013,my labtop is windows7 32bit running office 2013 32 bit. Missing something simple here I think,just can't get a finger on it.Maybe someone that tried it and saved with a different password can post that workbook with password and will try that.I will try anything right now.
The common factor still seems to be Office 2013.
Will see if I can get someone else to look at it.
Regards, TMS
Works fine for me in 2013 and Windows 10
Here ya go Z...pw is 5678
Z send-email-from-excel-to-outlook-vba-password.xlsm
Thanks gmr4evr1 for the test,same results on my end. My goal in life will get this to work no matter how long it takes. All this does not make since,different machines and different results.
Z
Someone, somewhere somehow, there is an answer....At least I hope there is.
LOL I want to Thank all you guy's for your help,it has to be something on my end.Going to set up another computer with all new installs. This will take some time but I will post back,I will not
sleep right and loosing a lot of hair over this.I'm not good at vba but know how it should work,Again Thank You.
Z
New Windows7
New Office 2013
You're welcome, and again, good luck.
Well set up new computer from scratch,newly formatted drive. Installed Windows7 and Office 2013. Ran the example file and all is the same.?? I must be missing something,installed all the office tools with Excel and Outlook.Should I try a Microsoft forum for help,is there one? This hole thing is making me a lot older.LOL.Could it be I live in Michigan and there is something in the air? About to give up and take this to my grave as not solved.
Z
You are probably closer to the magnetic North Pole than the rest of us. It's probably magnetic field related. Drive to Texas and see if the problem goes away.I live in Michigan and there is something in the air?
I'm here waiting for y'all.....Drive to Texas and see if the problem goes away
Have posted problem on other forums,will let you know if a fix is found.Will stay on top of this so I don't waste anyone's time. Thank You
http://www.excelforum.com/excel-prog...tpassword.html
http://www.mrexcel.com/forum/excel-q...tpassword.html
Fix is in place. Hope this might help someone down the road.
http://www.ozgrid.com/forum/showthread.php?t=196515
Please Login or Register to view this content.
YAY! I'm glad you were able to get it resolved. Now we can all sleep peacefully again.
Ditto. Thanks for the update and code. Tried it and it works for me ... though I guess I didn't have the problem in the first place.
That said, always interesting to have new examples, particularly late binding.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks