Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|