Many years ago, we matched our small parts inventory item numbers to that of a big supplier of such items. If they sold a screw as P/N98010A541 this is what we would use in our inventory system. Good idea at the time as everyone knew the numbering system and could immediately identify the primary supplier. Unfortunately, that supplier has since re-numbered their inventory...so what once meant something, now relates to (at best) an obsolete product number or (at worst) a completely different item. Imagine KNOWING that item 1123K93 is the desired lockwasher, only to have 1000's of shop towels (or bars of soap, moving dollies, material strainers, etc.) arriving just-in-time to screw up your outgoing shipment.
We could of course manually check each part number in our database, searching for the correct replacement part number where applicable, but I would rather like to scrip a query to the suppliers web site (where they have a nice "Find" box in one of their frames) and read back to Excel a list of what the big supplier believes these items are...
I've tried doing this, using the Excel Web Query, only to have this fail (returns a note that "Our web site makes use of JavaScript features. Click on your browser type for instructions on enabling JavaScript...")
So how can I automate a query for a couple hundred "Find"?
We could of course manually check each part number in our database, searching for the correct replacement part number where applicable, but I would rather like to scrip a query to the suppliers web site (where they have a nice "Find" box in one of their frames) and read back to Excel a list of what the big supplier believes these items are...
I've tried doing this, using the Excel Web Query, only to have this fail (returns a note that "Our web site makes use of JavaScript features. Click on your browser type for instructions on enabling JavaScript...")
So how can I automate a query for a couple hundred "Find"?