ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Interactive web browser object embedded in an Excel print (https://www.excelbanter.com/excel-programming/431475-interactive-web-browser-object-embedded-excel-print.html)

Michelle Bradley

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