View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sgl sgl is offline
external usenet poster
 
Posts: 80
Default DisplyaAlerts Problem

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