asked on

VBA codes for running and saving reports from external software (AUTOIT maybe ???)

Hi,
Every week, I need to run 7-8 reports from external software for same week period for almost 8 branches, is there any VBA codes which can help me to automate the process, where it saves all reports automatically from external software on network directory just by adjusting dates? Your help will be appreciated.

SOLUTION

Bill Prew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Michael Coloun

ASKER

we use a software called Qcare, I have attached the file which tells what exactly required, I need a macros to run different reports, if you create one macro for one report, I can copy and try for rest of the reports using the same codes with little modifications. let me know if you need any more details, I really appreciate your efforts and help it can save lot of my time and stress.
Qcare.docx

Michael Coloun

ASKER

to continue further these reports are open in PDF format and save on the network for further use.

ASKER CERTIFIED SOLUTION

Bill Prew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Joe Winograd

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Joe Winograd

Bill's first comment about easily automating via a CLI, but needing more information to answer accurately, is spot-on, as is his second comment about using AutoIt. My comment about using AutoHotkey is in the same spirit as using AutoIt. Splitting the points evenly between the two experts. Regards, Joe