How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 36117
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

Richard, I am trying to open a intranet site, using a button

This answer was rated:

I am trying to open a intranet site, using a button control to open the page. You had provided the code to open an excel workbook, can you let me know what I need to modify the code, so I can open the following "htm" webpage?

This is the page I am needing to open, with the button click:
\\victorysrv1\Share\Bobby\Intranet\Canopy bid calculator\Canopy bid calculator.htm

This is the code I currently have for opening an Excel workbook:
Sub Button145_Click()

Dim xl0 As New Excel.Application
xl0.Visible = False
xl0.Workbooks.Open "\\VICTORYSRV1\Share\Awning Images\Overhead_6S-RF.xlt"
xl0.WindowState = xlNormal
xl0.Visible = True

End Sub
Thank you for your question, my name is Richard.

You need to use this code.

Dim ie As Object
ie.NAVIGATE "\\victorysrv1\Share\Bobby\Intranet\Canopy bid calculator\Canopy bid calculator.htm"
ie.Visible = True

This will open IE to your page.

Let me know if you have any difficulties please

Customer: replied 3 years ago.

That works, it opens the IE to the page, is there a way to specify the size window that opens though? When it opens the page it is in a minimal window, I do not want it to open in maximum, but if I can set the parameters of the window size, that would be great, so it opens to the exact size showing everything necessary on the page.

yes you can by using before

ie.visible = true

You add

ie.Width = "100"
ie.Height = "400"

Change the values to get the size you wish Curtis.

Let me know if you have any difficulties please

Richard and 3 other Microsoft Office Specialists are ready to help you