Macro doesn't run...

[JVLennox]

Hi everybody,

I have a small Makro, but it doesn't run... :-(

The Makro is supposed to look up the IP-Adress which it finds in the Logfile in a EXCEL-woksheet and take the corresponding CustomerID and write it into a NEW logfile.
NOW, somehow I get an Error like Runtime-Error 5: Invalid procedure or argument

I am not good with VBA, so I actually don't understand what I do wrong.... :-(

Please Login or Register  to view this content.

Inside the code I marked where the error occurs....

THANKS!!

[Leith Ross]

Hello JVLennox,

You don't mention what error you're getting, but I suspect that sPos is returning a zero at some point during the file read. If you have lines in the file that don't contain the search string " - - ", sPos will be zero. Place a breakpoint at this line in your code:

sKdNr = KdNrSuchen(Mid(sText, 1, sPos - 1))

Check the value sPos and then press F5 to step through your loop.

Sincerely,
Leith Ross

[JVLennox]

Wow, I guess I was blind... :-)
Well, thats what happens :-)

Thanks!