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.
The above line is not working .... neither it is giving an error in the vb editor
please find the attached macro file