Excel, Ascii, Printing

JOLTRON

Lifetime Supporting Member
Join Date
Aug 2006
Location
MI
Posts
692
I have an excel file with 400 rows of 5 columns of information. I have been asked to etch these each row of information on a metal tag using a Technifor Pinstamp Unit.

I was hoping to create a formula that would pull the information into some sort of string that I could send to the printer with hyper terminal.

My problem is:
String format required = <ESC> VR 1 texttexttext <CR><ESC> VR 2 texttexttext<CR>

I cannot figure out how to creat the escape or carriage return symbol in excel.

Does anyone know how to do this or an easier way to send the daya?

Any input is appreciated.
-Joel
 
if you copy and paste excel data into notepad before you save it, CR is automatically appended after each line.
for ESC try this

=CONCATENATE(CHAR(34),A1)
 

Similar Topics

If there are any Excel guys there that know how to convert a decimal value from ControlLogix to Ascii in Excel I sure would appreciate it.
Replies
25
Views
5,017
Do any of you Excel gurus know of a VB code or function that will convert ASCII text into it's decimal equivalent? I'm not VB savy at all. I...
Replies
3
Views
5,830
Hi, I'm trying to export data from a DataGrid to Excel using VBA, but I'm getting an error "Object doesn't support this property or method". The...
Replies
0
Views
77
I don't know if this is the right place for the subject at least I'll try. The company has one of the oldest computers that is a master Windows...
Replies
5
Views
740
Hi, I'm just looking for a simple way to make a button in excel (via VBA I presume) to toggle a bit in RSLogix 5000. I just got FactoyTalkLinx...
Replies
9
Views
545
Back
Top Bottom