we use barcode scanners to list our books for sale on amazon but when we are at a book fair we want to be able to scan books into excel and have it return the book title, author and other book information, but can't work out how to do it!
it seams that practically everyone at the book fairs has this facility but i've not been able to find anyone willing to tell us how it works.
can anyone help?
obviously we've done lots of web searches for macros and that kind of thing but of course as soon as you put in isbn you get loads of results about excel books and how to write macros from pages where a book is listed with its isbn number.
looking forward to getting to the bottom of this if anyone has the solution
best regards
roger|||Yes, it is a macro
Based on your additional details, yes, you need to do a macro
I can sure do it for you, just let me know (By mailing me here) the website, or the database that the macro needs to search in it
Then I would send you some sample Excel file that will search that db and return the details that you need
Trust me, VBAXLMan is here to fill your Excel needs|||VLOOKUP should work. Have you tried this? But Microsoft Access may be better for what you are doing.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment