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.
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.