RasGetConnectionStatistics
 

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.

RasGetConnectionStatistics
 

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

pete wrote:

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.