Howdy. Brand new to the excel groups... Hope you'll forgive me. I'm
traditionally an Access user. My new employer doesn't have it and
isn't likely to get it. We have a situation that is very time
consuming and I'd like to hear the opinion of the experts. At my work
we basically scan barcodes from product into an excel spreadsheet.
After a long list of about 300 to 500, we are to check those barcodes
against an online database of reliable parts. Great, except that the
interface for that website will only allow the data from one barcode
at a time. Right now we must copy and paste each one. Very time
consuming. In Access, I could probably dream up a way to accomplish
this using VBA, and I'm sure the solution is similar in Excel, but I'm
not sure. Can anyone point me in the right direction?

You could probably do something very similar with VBA in Excel. I've not
used Access, so I don't know what the similarities/differences are with VBA.
If you have some specific questions, don't hesitate to ask.
--
HTH,
Barb Reinhardt



"Jaybird" wrote:

Howdy. Brand new to the excel groups... Hope you'll forgive me. I'm
traditionally an Access user. My new employer doesn't have it and
isn't likely to get it. We have a situation that is very time
consuming and I'd like to hear the opinion of the experts. At my work
we basically scan barcodes from product into an excel spreadsheet.
After a long list of about 300 to 500, we are to check those barcodes
against an online database of reliable parts. Great, except that the
interface for that website will only allow the data from one barcode
at a time. Right now we must copy and paste each one. Very time
consuming. In Access, I could probably dream up a way to accomplish
this using VBA, and I'm sure the solution is similar in Excel, but I'm
not sure. Can anyone point me in the right direction?

Thanks. The interface is completely different in Excel, so I'm not
sure where to turn... I'm assuming that I have to create a button
that starts a macro or a VBA module. Some of the posters have done
similar things but I don't know the terminology, so my searches of the
discussions are hit and miss. I have read references to a web query
that could conceivably upload the information one scan at a time, but
I'm unfamiliar with the web design of the site, and can't seem to get
it to work. Does anybody know what it is that I might be looking for?

I suggest doing a little more research on the website to see if it is
possible to download the part numbers then compare or even better see if you
can get a backdoor connection via SQL at which point you could querry the
database behind the web interface.

"Jaybird" wrote:

Howdy. Brand new to the excel groups... Hope you'll forgive me. I'm
traditionally an Access user. My new employer doesn't have it and
isn't likely to get it. We have a situation that is very time
consuming and I'd like to hear the opinion of the experts. At my work
we basically scan barcodes from product into an excel spreadsheet.
After a long list of about 300 to 500, we are to check those barcodes
against an online database of reliable parts. Great, except that the
interface for that website will only allow the data from one barcode
at a time. Right now we must copy and paste each one. Very time
consuming. In Access, I could probably dream up a way to accomplish
this using VBA, and I'm sure the solution is similar in Excel, but I'm
not sure. Can anyone point me in the right direction?

On May 5, 10:12*am, dmoney wrote:
I suggest doing a little more research on the website to see if it is
possible to download the part numbers then compare or even better see if you
can get a backdoor connection via SQL at which point you could querry the
database behind the web interface.

Hmm... I haven't tried an ODBC connection. Maybe that's possible.
But considering how little support we get from IT at this level, I
doubt I have the permissions. I was trying to do and end run around
them.

would an external query to the website help. Give the url and what you want.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jaybird" wrote in message
...
On May 5, 10:12 am, dmoney wrote:
I suggest doing a little more research on the website to see if it is
possible to download the part numbers then compare or even better see if
you
can get a backdoor connection via SQL at which point you could querry the
database behind the web interface.

Hmm... I haven't tried an ODBC connection. Maybe that's possible.
But considering how little support we get from IT at this level, I
doubt I have the permissions. I was trying to do and end run around
them.

Hey, thanks... Here's the url:

https://report.converge.com/dell/int...ck_battery.php

Perhaps if you can figure out what kind of query will work, you can
point me in the right direction. I would very much like to figure
this stuff out, so I'm moving one step at a time and asking for help
when I need it. Thank you for your help.

PPID


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jaybird" wrote in message
...
Hey, thanks... Here's the url:

https://report.converge.com/dell/int...ck_battery.php

Perhaps if you can figure out what kind of query will work, you can
point me in the right direction. I would very much like to figure
this stuff out, so I'm moving one step at a time and asking for help
when I need it. Thank you for your help.

But then Thomas Gray never said it was; what he said was

"Where ignorance is bliss, 'Tis folly to be wise."

Alan Beban

Thanks for that... I think.