Interactive web browser object embedded in an Excel print
Hi,
I need to be able to print an Excel spreadsheet with an embedded web browser object. When I print, the spreadsheet is visible but the object is not visible. The object is generated by an address entered into Google maps. I am a total newbie however I usually can figure problems out given enough time. This time I am stumped. This is to code that I am using. Any help would be appreciated. Thanks Private Sub CommandButton1_Click() ActiveSheet.Shapes("WebBrowser1").OLEFormat.Object .Object.Navigate2 _ "http://maps.google.com/maps?output=embed&z=8&f=q&source=s_q&hl=en&geocode =&q=2001+ellis+road,+32254" End Sub Private Sub WebBrowser1_StatusTextChange(ByVal Text As String) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub -- Michelle Bradley |
All times are GMT +1. The time now is 08:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com