Im trying to do something abit tricky...
Ive got a page which grabs external data,

The thing is... multiple sheets will be using this same page, however the
page will change every time, so I want to be able to update all sheets...
without having to do them one by one...

I was thinking.. maybe making a macro...

which would goto a cell... in which I would enter the url... and then the
macro would copy it.... goto the page... goto the external data
properties... paste in the url... press ok.. and then move on to the next
page thats needs doing... however.. in recording a macro.. I cant paste....
Im not sure why... you can normally paste into the external data
properties.. but not while recording a macro...

anyway... here is what the macro comes up with.... without pasting,,,,, so
im wondering is there anyway to either get the URL to use a cell .. or to
paste it in some how..... hopefully someone out there is clued up on this
side of scripting....


Range("B19").Select
Selection.Copy
Sheets("sheet1").Select
Range("A1").Select
Application.CutCopyMode = False
With Selection.QueryTable
.Connection = _
"URL;http://www.testing.com"
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "4,8,12,16,20,24,28,32,36,40"
.WebPreFormattedTextToColumns = False
.WebConsecutiveDelimitersAsOne = True