LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 19
Default internet connection via excel macro at timed intervels & save data to excel file.

Hi Gang,

I looked around and found bits and pieces to what I was looking for
but did not find all the pieces to put it all togther.

What I am looking to do is use a macro to:

1. Access a company website website once a day (example: 5:45am).
2. Tab over a couple of radio buttons to get a section I need to
download data from ( I think I can do this)
3. Run a query from the website. (essentially clicking on a single
button to extract data from the past 24 hours)
4. Copy all of the data the data that returns (Control A).
5. Paste it unto a blank MS Excel file and save on my computer in a
pretermined folder.

As always my sincere thanks to all the members in the forum!

Sam

 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
internet connection via excel macro at timed intervels & save data to excel file. Sam Excel Worksheet Functions 1 July 22nd 07 06:08 AM
msn stock updates quit working & no internet connection in excel K9CE Excel Discussion (Misc queries) 0 July 13th 06 04:36 PM
Using Macro to save data in new excel file Spartanz Excel Programming 6 March 2nd 06 01:21 PM
internet connection via excel macro J_J[_2_] Excel Programming 2 October 18th 05 08:26 PM
How do get the internet connection wizard for Excel? Excel 2003 E-Mailing Help Please Excel Programming 0 August 27th 05 05:47 PM


All times are GMT +1. The time now is 02:55 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"