Id like to start by saying, You all have been a God send for me and i am glad that i joined this fourm. Not only am i
learning alot but im able to complete projects that have been thrown aside due to lack of knowledge. So here is my issue. I
found this code below on another site and would like to use it or maybe someone has a better idea. I need to import text
files into my active sheet.
The text files are created by a magnetic stripe encoder and look like this: "%Fname
Lname address city st. zipcode telephone?;member number?"( minus the "" they are there for seperation factor only. % . ; ?
are there just as you see them) so im sure the data will have to be trimed. Field names are as follows in this order:
Member Number, First Name, Last Name, Address 1, Address 2, City, St, Zipcode, Phone
What im wanting to do
1: read the card with a mag stripe reader into a "collection window" so to speak and have it input the data
into the named fields OR
2: have a macro that can open a selection window so the user can choose the text file
then have the macro read the text into the named fields.
' Modify the constants below according to your import configuration
Const qName = "Pro_Co_Serv_Eval_NM" ' 0 Then
' Something else
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines