I am currently using the ExportToXl macro. What I do is I create batch files that launch my SAS programs that contain this macro. Everything works fine as I have done at many other job locations. however where I currently work I have a problem.
When I am not logged on and my batch file program is running at night the SAS program haults at the point of where it is to create the Excel spreadsheet (run the macro).
Has anyone run into this before. My guess is this must have something to do with permissions or policies.
Thanks
Paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am currently using the ExportToXl macro. What I do is I create batch files that launch my SAS programs that contain this macro. Everything works fine as I have done at many other job locations. however where I currently work I have a problem.
When I am not logged on and my batch file program is running at night the SAS program haults at the point of where it is to create the Excel spreadsheet (run the macro).
Has anyone run into this before. My guess is this must have something to do with permissions or policies.
Thanks
Paul