Web Query date parameters

  • Thread starter Thread starter DW
  • Start date Start date
D

DW

Hi,

I have numerous individual web queries maintained in spreadsheets that I
need to update bi-monthly.
It works fine except that each time the month changes I have to go in and
revise the date for the query paramaters to coincide with that in of the
server.

I tried developing a macro but the macro would not recognize the queries as
individual entities thus it fixed the date but kept the data from the first
sheet throughout the remaining sheets.

I also tried going into options and disabling date recognition but it did
not work either. I something in data range properties that might work?

I am new to newsgroups and it comes highly recommended - I am grateful for
any.
 
DW said:
Hi,

I have numerous individual web queries maintained in spreadsheets that I
need to update bi-monthly.
It works fine except that each time the month changes I have to go in and
revise the date for the query paramaters to coincide with that in of the
server.

I tried developing a macro but the macro would not recognize the queries as
individual entities thus it fixed the date but kept the data from the first
sheet throughout the remaining sheets.

I also tried going into options and disabling date recognition but it did
not work either. I something in data range properties that might work?

I am new to newsgroups and it comes highly recommended - I am grateful for
any.
 
Back
Top