AnsweredAssumed Answered

Excel Macro for Auto Reporting

Question asked by samsonaa on Feb 9, 2015
Latest reply on Feb 13, 2015 by Dan Fishman

Hi,

 

 

we are having a data link report which uses excel 2003. We want to automatically send this datalink report via email to the concerned people in the plant.

 

 

We are using excel macro to generate the workbook and save it in a particular folder and email this file.

Using Vb script we are calling the macro which does the job. This vb script is then run via Windows task scheduler.

 

 

the macro should save the calculated values in the folder first and then it should sent it via email.

The problem lies with the macro

 

We have developed a macro. but its not calculating the values.

Line7: Worksheets("ReportDate").Calculate  

The above line is not working .... neither it is giving an error in the vb editor

 

please find the attached macro file

Attachments

Outcomes