Re: Add worksheets with Web Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

Why do you need a separate query for each day? Lots of resources used.
I would suggest ONE query (with the day variable)>pull data to template ***>copy template ***>name it with date.
--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"herbwarri0r" <herbwarri0r.bd723f@xxxxxxxxxxxxxxx> wrote in message news:herbwarri0r.bd723f@xxxxxxxxxxxxxxxxxx

I need some VBA to add worksheets in date order. For example I will name
the first sheet 01012007, I then need a macro to add sheets for one
quarter up to 31032007 but only for weekdays.

On top of this once the sheets are added I need a web query to be
performed on each tab. The url will be in the format of
http://domain.com/01012007.html. The url will only exist from the day
before it's name and I will need data to be refreshed upon opening the
workbook for all urls less than 3 days old.

Really appreciate any help on this one. Oh I have been looking at the
code at the bottom of this page http://www.ozgrid.com/News/jan-2006.htm
but couldn't get it to work for me.




--
herbwarri0r

.

Quantcast