Wow, thank you very much for your help. I promise you I will pay my utmost attention to the contents of the link you kindly sent me (IEOBJ). It'll be my first contact with this tool but I'm a fast learner. Thank You & all the best.
FY
jacaranda
Last Activity: Nov 18 '13, 12:47 PM
Joined: Nov 8 '13
Location:
-
You are absolutely right: Why open it? Ok, this is the case:
The Excel spreadsheet shows me a Radio Station's complete schedule for the week. Several Excel functions tell me exactely which DJ is on the air any time, with his name, photo, program name and timetables. Until here all's well!
However when the workbook opens, the macro Workbook_Open is "fired", opening a link to the streaming html page, so that I can hear the radio...Leave a comment:
-
You mean: object.ClientTo Window? I've tried but returns an error!...Leave a comment:
-
I'm sorry, can you be more specific? I don't really know how to put it any other way. The link opens the page correctly but the opened window comes to the the front of the Excel window and I want it minimized or in the background, keeping the focus on the spreadsheet. Of course, I can do it (minimize de window) manually, but then again in that case I wouldn't come here for help. Thanks, anyaway!...Leave a comment:
-
Open Hyperlink Minimized or Hidden
I'm trying to open an hyperlink, which is in fact an online streaming station, with a macro in Excel, like:
But the page opens in full screen format and I want it to open minimized with the focus on the Excel sheet or hidden.Code:Sub MyMacro() ActiveWorkbook.FollowHyperlink Address:="http://www.lmradio.net/streaming.html" End Sub
Can you help me?
Thanks.
No activity results to display
Leave a comment: