LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jon
 
Posts: n/a
Default Using a VB Script for barcodes - new to this

Hello group,

Wonder if someone can help.

I'm attempting to create a sheet of barcodes. I've found some barcode
fonts and a VB script which when used together produce results that
work, I.e. valid barcodes.

The process is thus: I use this script to input a 12 digit number, when
I press "generate" the script turns my 12 digits into a string of
characters. I then paste this string of characters into an excel cell
and format it using the barcode font. The result is a barcode which when
sized up to 48 and printed works on my barcode scanner.

What I want to do is to be able to utilised this script somehow in excel
but I have no idea how to do this.

Ideally What I want to do is take the contents of cell A2, put it
through this script and dump the output into cell A1.

Is this possible?
--
Regards
Jon
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Read only password script box Joey041 Excel Discussion (Misc queries) 1 May 3rd 05 01:23 AM
Can somebody check my script?? Anthony Excel Discussion (Misc queries) 3 March 2nd 05 09:31 AM
Macro script error - pls help !! Anthony Excel Discussion (Misc queries) 3 February 28th 05 01:49 PM
Script Error Mike Excel Discussion (Misc queries) 1 January 29th 05 12:32 AM
How do I get the trendline equation from Excel to script? Mattias Charts and Charting in Excel 1 December 7th 04 12:21 PM


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"