I am using Excel - VBA Office 2000-2003 and Office 2007

I have an application/Function that imports a webpage into a worksheet. On
connection a display showing the URL Path.

I need to supress this so that the user cannot view it. I have tried using
the following in my VBA code but they do not work. Part of the vba code
includes the following:

Application.DispayAlerts=False
Application.AskToUpdateLinks=False

Set objBK=Workbooks.Open("http://www.google.com")

Any ideas on how to avoid URL alerts.

Thnaks/sgl

If you're talking about the alerta that are displayed in the status bar when
a workbook is opened, I'm not aware of a way to suppress this.
--
HTH,

Barb Reinhardt



"sgl" wrote:

> I am using Excel - VBA Office 2000-2003 and Office 2007
>
> I have an application/Function that imports a webpage into a worksheet. On
> connection a display showing the URL Path.
>
> I need to supress this so that the user cannot view it. I have tried using
> the following in my VBA code but they do not work. Part of the vba code
> includes the following:
>
> Application.DispayAlerts=False
> Application.AskToUpdateLinks=False
>
> Set objBK=Workbooks.Open("http://www.google.com")
>
> Any ideas on how to avoid URL alerts.
>
> Thnaks/sgl
>
>

Turn off the status bar while loading the new URL:

Application.DisplayStatusbar = False

....your code here

Application.DisplayStatusbar = True

Also, the name of the worksheet tab has the URL, so you would need to change
that before it is visible to the user. Also, the default workbook name
becomes "www.google.com", so you would want to change that too.

HTH,

Eric

"sgl" wrote:

> I am using Excel - VBA Office 2000-2003 and Office 2007
>
> I have an application/Function that imports a webpage into a worksheet. On
> connection a display showing the URL Path.
>
> I need to supress this so that the user cannot view it. I have tried using
> the following in my VBA code but they do not work. Part of the vba code
> includes the following:
>
> Application.DispayAlerts=False
> Application.AskToUpdateLinks=False
>
> Set objBK=Workbooks.Open("http://www.google.com")
>
> Any ideas on how to avoid URL alerts.
>
> Thnaks/sgl
>
>