View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] donaldrnoble@yahoo.com is offline
external usenet poster
 
Posts: 2
Default Excel Workbook Address in VBA


Jake Marx wrote:
Hi Donald,

Not sure if this will work, but it's worth a try:

MsgBox Application.CommandBars("Web").Controls(10).Text


That works perfectly, as long as the web toolbar hasn't been cutomised.

After some searching, trial, and errors, I found that the name of this
control is actually "Address:" including a colon!

so MsgBox Application.CommandBars("Web").Controls("Address:" ).Text
works as long as the Web toolbar has the address field.

Thanks again for your help