Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print a static date from a barcode
Hello,
Im creating a very simple track and trace system for use only to my own packages. And i need excel to type todays date when it reads a barcode. And the date needs to be static. Any ideas on how to do this? - im not the big programmer så im lost :) As far as i can see it can not be done "out of the box". I cant find any barcode that could give me CTRL+SHIFT+; (static date). So im looking for another way of doing it :) Regards, Dennis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
print a static date from a barcode
Do you mean enter the current date instead of the read barcode, or enter the
date in a cell next to the barcode entry ? How do you currently read the barcode? Select a cell and then scan, or what? Most posters here (inc. myself) may not be too familiar with barcodes, so you could provide more details there. I'm thinking you could use the worksheet_change event, but it depends on how "general" you want this feature to be (one specific workbook?) Tim "Dennis Pedersen" wrote in message ... Hello, Im creating a very simple track and trace system for use only to my own packages. And i need excel to type todays date when it reads a barcode. And the date needs to be static. Any ideas on how to do this? - im not the big programmer så im lost :) As far as i can see it can not be done "out of the box". I cant find any barcode that could give me CTRL+SHIFT+; (static date). So im looking for another way of doing it :) Regards, Dennis |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
print a static date from a barcode
"Tim Williams" <timjwilliams at gmail dot com skrev i en meddelelse ... Do you mean enter the current date instead of the read barcode, or enter the date in a cell next to the barcode entry ? How do you currently read the barcode? Select a cell and then scan, or what? Most posters here (inc. myself) may not be too familiar with barcodes, so you could provide more details there. I'm thinking you could use the worksheet_change event, but it depends on how "general" you want this feature to be (one specific workbook?) When i am filling out my return.xls - instead of typing Name,date,package number. I just want to scan the barcodes on a paper i have. The scanner just works as a USB keyboard (with the limitation i can only type "123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-.*$/+%"). When i scan a barcode it enterns the value in the current field in excel Therefore i need a combination of the above caracters that could give me static version of the date today. Since i cant get it out of the box i am open to any ideas on how excel can convert the caracters above to the date. Hope that clears thing up a bit Regards, Dennis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DAYS360 where Start Date is Static and End Date is Latter of Two Dates | Excel Discussion (Misc queries) | |||
can I create and print a barcode | Excel Discussion (Misc queries) | |||
Can you print barcode labels using excel or word? | Charts and Charting in Excel | |||
Barcode ActiveX Control will not print properly | Excel Discussion (Misc queries) | |||
I need to print lists including a barcode in Excel. | Excel Discussion (Misc queries) |