98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
Excel VBA
Resolved · Medium Priority · Version 2010
Mon 4 Mar 2013, 14:48Delegate Adrian said...
Adrian has attended:
Excel VBA Intro Intermediate course
Excel VBA
I have some code that opens IE 9 and inputs my log in details to our intranet and selects a report i want to run and it works however I would like to amend it. After it has loged in it then opens the report in a second IE window. I like it to stay in the same IE window or open in a new tab., any help would be appreciated, let me know if you need to see what I have so far.
Mon 4 Mar 2013, 14:54Trainer Gary said...
RE: Excel VBA
Hi Adrian
Thanks for getting in touch. Sounds like you have a great routine running there!
This isn't something I've programmed before personally but I've searched around and found the following link, which has a variety of solutions:
http://www.mrexcel.com/forum/excel-questions/553580-visual-basic-applications-macro-already-open-ie-window.html
I've tried some of the solutions and they do exactly as you request. You just need to integrate them into your solution.
I hope this helps, please get in touch if it's not working for you.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 11 Mar 2013: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Ctrl+d's double lifeSuppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae. |
