Query machine with Office 2000 w/o Office 2003

I am trying to create a query that will tell me which machines have Office
2000 installed and NOT Office 2003. Reason being is we have one application
that requires Excel 2000. So if I create a collection based on a query that
has Office 2000 installed, it sees Excel 2000 and thinks that it need to
install office 2003, when in fact, it may already have 2003, and excel 2000.
My current query is based on add/remove programs....If Add/remove
includes;Office 2000.....and NOT add/remove Office 2003.....But I am still
getting all machines as if I have not included the not statement....

Please advise


.

Relevant Pages

  • Re: Excel "Web Query"
    ... write a macro to find a reliable source. ... .....I've been using Excel's "Web Query" for a while now but I've ... on "some" machines and not others. ... So, upon further investigation, it appears when you "Edit Web Query" ...
    (microsoft.public.excel)
  • Re: Excel "Web Query"
    ... .....I've been using Excel's "Web Query" for a while now but I've ... on "some" machines and not others. ... I know.....aren't pretty much ALL web queries used to do this :-) ... So, upon further investigation, it appears when you "Edit Web Query" ...
    (microsoft.public.excel)
  • Re: Design view (select query with link table issues)
    ... but they do not work on some user's machines? ... you try to open the table directly in the database window, ... you are talking about a query that draws from tables that are not ... >> permissions, Windows user permissions, or file-share permissions. ...
    (microsoft.public.access.queries)
  • Re: Union Query works on my PCs but not on clients machines
    ... will check all that out next time I visit the client. ... > To check the file versions between the two machines, ... The query contains undeclared parameters, ... >> office machines and updated it in the same way I updated my home PC. ...
    (microsoft.public.access.queries)
  • RE: Collection not showing ALL of the clients correctly
    ... I created the new Collection and Query but ... Is there any troubleshooting to do at the client level? ... with all the machines that met that criteria, I selected all of them and it ... the machines I am still missing 3 machines. ...
    (microsoft.public.sms.admin)
Loading