RasGetConnectionStatistics

P

pete

I'd like to create a simple program that grabs the stats from my RAS
connection each time I connect to my ADSL provider via Dial-Up
Networking (i.e., date, time, connection time, bytes sent, bytes
rec'd) and keeps it in an Excel-compatible file. That's *all* I want
the program to do (no silly stuff popping up out of my system tray).
Can I do this with VBA?

I know Windows store this info in HKEY_DYN_DATA\PerfStats\StatData.
 
Y

yogendra joshi

Use This :
==============================================================
Sub import()
Workbooks.OpenText Filename:="d:/test.txt", _
DataType:=xlDelimited, tab:=True

End Sub
==============================================================

You can select the Data Type, the break caracter etc etc.

For more info .. see help for "OpenText Method" in VBA help.

Hope this helps

Yogendra
 
Top