Prev: Use specialcells to identify specific values
Next: Selecting Multiple columns with multiple rows
From: sgl on 9 Apr 2010 06:27
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


From: Barb Reinhardt on 9 Apr 2010 07:15
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
>
>
From: EricG on 9 Apr 2010 11:24
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
>
>
 | 
Pages: 1
Prev: Use specialcells to identify specific values
Next: Selecting Multiple columns with multiple rows