Automation Software?

[Syringer]

What we need is a solution to automate a lot of tasks which include:

-d/ling files from HTTP pages
-running MS Access + Excel files
-deleting/renaming certain files

Among others, and need them to be done on a daily basis. I've tried Automize 8 which worked for a while but the interface is terrible. Does anyone have any alternatives?

 

[Miramonti]

Well, the best easy to use yet highly capable software is probably Automate, but its priced these days ridiculously high, mainly for corporate users. I got my licenses a while ago when it was cheaper and I've become completely dependent on it to do a ton of various things during work.

 

[Syringer]

Wow the software demo looks great, but it's probably out of our company's budget =/

 

[gsaldivar]

Would something like this work? http://www.winautomation.com/

 

[yinan]

AutoIT, vbscript, powershell?

 

[Ken g6]

-deleting/renaming certain files

This may be the toughest. What are the rules for the deletion/renaming? Personally, I'd just use Perl for this. To delete, use "unlink".

-d/ling files from HTTP pages

You can use Perl for this (LWP::Simple). Or you can use WGet.

-running MS Access + Excel files

I'd use VBA for stuff within Microsoft products. That's what they put it there for.

Anything else you need automated?

 

[chronodekar]

I think Autoit would do the job.

-chronodekar

 

[Modelworks]

Autoit can do that and more. Combine it with autohotkey and there really isn't anything you cannot do. Both are free.
http://www.autohotkey.com/

 

[chronodekar]

Autoit can do that and more. Combine it with autohotkey and there really isn't anything you cannot do. Both are free.
http://www.autohotkey.com/

Autohotkey is new to me and looks interesting. I'm bookmarking it. thanks !!


-chronodekar

 

[ozone13]

Check out www.watchdirectory.net.

I've also had a lot of luck using the automation function of GetRight (server sync + daily download) www.getright.com.

 

[Zorba]

You could use VBA at least the last two. I am pretty sure that you could use VBA for downloading the files also.

File renaming/deletion is very easy in VBA.