#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Automation

Ok I will do my best to describe exactly what I need.

I have a daily report that I need to download from the company's secured
website, it requires username and password.

I then request to open the file in which I delete the security rows and then
save that file on my desktop. The file downloads as a Text (tab delimited),
so I have to save it as an Excel Spreadsheet in order for me to upload it
again.

I then go to another website, again requires username and password, and then
upload the Excel Spreadsheet I just saved on my desktop.

I have to make sure that it was uploaded and that the numbers populate after
the upload.

So now my question is how can I automate this so that it does it
automatically, I will need it during a specific timeframe, morning and
afternoons.

Is this feasible or am I asking for too much of Excel to perform?


--
Thank you all for your support and guidance. What would we all do if it
weren''t people like you out there to help us? Thank you!
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation Q Rick Excel Programming 0 August 30th 07 08:02 PM
Supressing the ctrl-c and other keys during word automation in automation apondu Excel Programming 0 July 19th 07 10:10 PM
Automation from VB6 Robert A. Boudra Excel Programming 2 November 16th 04 11:20 PM
about OLE automation keyur Excel Programming 0 April 5th 04 02:54 PM
OLE Automation Bob C. Excel Programming 1 December 9th 03 12:37 AM


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