Learn How To Automate Excel Reports

Asked By D Wright 10 points N/A Posted on - 08/01/2016

Hi. I would like to know the steps so as to know how to automate Excel reports? Please reply ASAP. Thanks in advance.

Answered By E Cho iLaw 1190 points N/A #95857

Hi. The steps to be followed so as to know how to automate Excel reports are as follows-

1) Using PivotTable make your report to summarize the data so as to identify the trends.

2) Open and close the report using Visual Basic script

3) To start the Visual Basic script, compose a batch script

4) To ensure that the output file is as it was created, write the batch script

5) Ensure that the desktop folder exists

6) Run the batch script sequentially even if someone is using the computer. Set the privilege to the highest setting possible.

Hope we helped.

Questions
20

Answers
19

Best Answers
0

Steps so as to know how to audit Active Directory