ExcelBanter - Need VB code for workbook open to open a link

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need VB code for workbook open to open a link (https://www.excelbanter.com/excel-discussion-misc-queries/105660-need-vbulletin-code-workbook-open-open-link.html)

Daniel Baker

Need VB code for workbook open to open a link

What would the VisualBasic code for workbook open look like to cause an
external web page or document to open when the workbook opens?

Bearacade

Need VB code for workbook open to open a link

Shell "C:\program files\internet explorer\iexplore.exe" & " " &
"HTTP://WWW.GOOGLE.COM", vbNormalFocus

--
Bearacade

------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=572860

Daniel Baker

Need VB code for workbook open to open a link

Works like a champ, thank you!

"Bearacade" wrote:

Shell "C:\program files\internet explorer\iexplore.exe" & " " &
"HTTP://WWW.GOOGLE.COM", vbNormalFocus

--
Bearacade

------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=572860

All times are GMT +1. The time now is 03:37 PM.