Can some body help in this simple problem ?
-- Forwarded message --
From: Balachander S
Date: Thu, Aug 6, 2009 at 10:26 PM
Subject: $$Excel-Macros$$ Trouble in changing url in Macro
To: excel-macros@googlegroups.com
I am trying to change the date in the macro for url address in
I am trying to change the date in the macro for url address in query as
follows . I get error . What am i doing wrong ?
dat = "04082009"
data = "URL;http://alco/funds/depadvpl1.asp?login=2014&rep_date1=&dat&";
With Selection.QueryTable
.Connection = data_
.WebSelectionType = xlAl
