Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"