• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Automation Software?

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?
 
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.
 
-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?
 
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.
 
Back
Top