I have a question about a work project I am working on.
My superisor wants me to somehow create a spreadsheet in
excel that would automatically retrieve values about
printer meters from a browser and then only allow the
values to be updated once a month. Then he wants these
values archived for data processing. He wants it set up
so there is no need for human intervention to prevent
careless data entry errors. All of the printers are Xerox
which come with a software package that allows you to
monitor printer meters online. How is it possible to do
that?

Right now I have the sreadsheet set up with a macro. I
recorded a macro that would perform web queries and store
the data in a seperate worksheet in the same workbook.
Then I linked the corresponding value back to the
spreadsheet. The problem with this is, how could I code
it to just refresh itself once a month and then archive
the data. I haven't done anything like this ever and I
don't know how to work it.

Thanks for your help.

Rhonda Carroll