Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Barcode and VBA
hi,
I use windows xp prof and office xp prof. i n excel i have add-in that generates for me bar code on the worksheet. i took add-in from www.abarcode.net and it is demo version. i have macro that does few steps for me. this steps a 1)copy value from cell A5 into N5 2)print a page with new barcode value 3)copy next value from A6 into N5 4)print a page with new barcode value ..... a there can be many values in A column and macro run to the last one that is not empty. and here is my problem: every printed page has always barcode with latest value from list, whenever macro goes normaly. i wanted to check exactly how does it goes and i used "step into" option of running macro. during this controled run everything was fine and each page has printed correctly with proper barcode. do you know how can i make this macro to print correctly on every single page?or what is the reason of such behavior? thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Barcode and VBA
Not sure I understand the problem, as you say it run fine normally and
stepping through the code. Either way, some code of the problem area would help. NickHK "Ice" wrote in message ... hi, I use windows xp prof and office xp prof. i n excel i have add-in that generates for me bar code on the worksheet. i took add-in from www.abarcode.net and it is demo version. i have macro that does few steps for me. this steps a 1)copy value from cell A5 into N5 2)print a page with new barcode value 3)copy next value from A6 into N5 4)print a page with new barcode value .... a there can be many values in A column and macro run to the last one that is not empty. and here is my problem: every printed page has always barcode with latest value from list, whenever macro goes normaly. i wanted to check exactly how does it goes and i used "step into" option of running macro. during this controled run everything was fine and each page has printed correctly with proper barcode. do you know how can i make this macro to print correctly on every single page?or what is the reason of such behavior? thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Barcode and VBA
Stepping through the code means that i press F8 and i see every single step
the macro does. Abarcode activeX add-in generates barcode from value that is placed in N5 cell. code is: dim idRow for idRow = 5 to 10 range("N5").select selection.value = cstr("=A") +cstr("idRow") ActiveWindow.SelectedSheets.PrintOut Copies:=1 next idRow any idea? Użytkownik "NickHK" napisał w wiadomo¶ci ... Not sure I understand the problem, as you say it run fine normally and stepping through the code. Either way, some code of the problem area would help. NickHK "Ice" wrote in message ... hi, I use windows xp prof and office xp prof. i n excel i have add-in that generates for me bar code on the worksheet. i took add-in from www.abarcode.net and it is demo version. i have macro that does few steps for me. this steps a 1)copy value from cell A5 into N5 2)print a page with new barcode value 3)copy next value from A6 into N5 4)print a page with new barcode value .... a there can be many values in A column and macro run to the last one that is not empty. and here is my problem: every printed page has always barcode with latest value from list, whenever macro goes normaly. i wanted to check exactly how does it goes and i used "step into" option of running macro. during this controled run everything was fine and each page has printed correctly with proper barcode. do you know how can i make this macro to print correctly on every single page?or what is the reason of such behavior? thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Barcode and VBA
The barcode is a font, the macro is not drawing the lines,
it is probably just creating a check digit and possibly setting the format of the cell to the barcode font. You can get free barcodes and algorithms in functions or macros to calculate check digits. See my page http://www.mvps.org/dmcritchie/excel...rg.htm#barcode and you can find freeware, shareware, and payfor barcode applications, entirely your choice. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ice" wrote in message ... hi, I use windows xp prof and office xp prof. i n excel i have add-in that generates for me bar code on the worksheet. i took add-in from www.abarcode.net and it is demo version. i have macro that does few steps for me. this steps a 1)copy value from cell A5 into N5 2)print a page with new barcode value 3)copy next value from A6 into N5 4)print a page with new barcode value .... a there can be many values in A column and macro run to the last one that is not empty. and here is my problem: every printed page has always barcode with latest value from list, whenever macro goes normaly. i wanted to check exactly how does it goes and i used "step into" option of running macro. during this controled run everything was fine and each page has printed correctly with proper barcode. do you know how can i make this macro to print correctly on every single page?or what is the reason of such behavior? thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Barcode Sequence | Excel Discussion (Misc queries) | |||
Barcode 128 B Add-In | Excel Worksheet Functions | |||
barcode- formals help please | Excel Discussion (Misc queries) | |||
barcode | Excel Discussion (Misc queries) | |||
Add Barcode | Excel Programming |