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
|