View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andym andym is offline
external usenet poster
 
Posts: 22
Default Dynamic variables in .WebTables

Dear All,

I wish to turn the line of code .WebTables = "4,8,12,16,20,24,28"
into something more dynamic.

In the above case I am pulling down 7 tables from the one web page. As
you can see they are every 4th table starting from table 4.

Sometimes, however, the number of tables change. If there are 10 tables
then I would be pulling down the following...

.WebTables = "4,8,12,16,20,24,28,32,36,40"

I want to have my code start off with an input box that I can state the
number of tables I need. I then need this variable to help create an
array that dynamically sets the .WebTables ... similar to .WebTables =
arrTables ... if this is possible to do...

Could anybody either confirm if this could be done, offer an
alternative, or guide me in anyway?

Regards,

andym