Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Macro for TNB 2

Status
Not open for further replies.

GioNorEricING

Technical User
Apr 13, 2010
7
MX
Hello,

I`m trying to use the following excel macro to convert TNB log file.

But I`m getting runtime error "Run-Time error 75, Path/File access error" everytime I run the TN conversion.

Does anyone know if it could be an issue with the log file format? Which format does the file should have? The log file was saved in C drive.

Thanks in advanced!!
 
try a diff version, theree are several on there. When I get run-time and say ok, or close it, it still completes the mission.

Mato' Was'aka
 
Thanks bigindian65!!

However, I have tried already different versions and still getting same run-time error. That is what makes me think that the *.txt file is incorrect, but don´t know what else to modify.

 
you have just the TNBs in there? Not a repetition of ld 11 or 20 header info right?

Mato' Was'aka
 
Right!! Below you´ll find a fragment.

REQ PRT
TYPE: tnb

TN

CDEN

CUST

DATE

PAGE

DES
TN 000 0 00 00
TYPE DTR
CDEN 8D
DATE 3 AUG 1994

TN 000 0 00 01
TYPE DTR
CDEN 8D
DATE 3 AUG 1994

TN 000 0 00 02
TYPE DTR
CDEN 8D
DATE 3 AUG 1994
 
My version, which is on Gene's web site should work OK. You will need to have "REQ" at the end of the TNB capture file. I've done a guide on how to use it and my contact details are in the excel guide. Please send me the list and I'll test it out. My last version was in Feb this year.

One of the main changes was to add in the extra add on module keys and also capture the number of the new 122x range of IP phones etc.

All the best

Firebird Scrambler
Meridian Programmer in the UK

If it's working, then leave it alone!.
 
Thanks again for your help!! It seems to be my windows version.
The macro is working fine on Win XP.

Regards!!
 
Its actually a problem with the macro.
I had to modify the MV macro so it will work on office 2007. While i was there i put in some extra goodies like 1140/1150 etc...
PM Me with your email and i'll send it to you :)
 
when desktop here changed versions of excel i had to grab a copy from the original website.. pepedog.com/meridian..

john poole
bellsouth business
columbia,sc
 
I've done two versions of the conversion utility program. One is the standard *.xls and the other is the *.xlsm for office 2007. Both versions use the root of the C:\drive to store the temp.prn file, when using the TNB conversion.

I don't have Windows 7, but I understand that there might be some restrictions when using the root C drive?. I may need to redo the macros.

All the best

Firebird Scrambler
Meridian Programmer in the UK

If it's working, then leave it alone!.
 
I was wondering if i could get an update of the tn-excel program? I just have this 1....
ConversionUtility(BARS-TNB-More)_by_DB.zip (Parse an TNB into Excel)

Ozzietech i can't figure out how to pm you?
Thank you



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top