rhbishop2

No. I have created a report definition in SIMS which produces the correct data when run and the data saved manually. As I understand it CommandReporter should create the same effect, saving the data to the specified location. But it doesn't.

I wish to export some data from Sims on a regular basis using VBA. I have created and saved a report definition in Sims which creates an xls file. I can run this report in Sims although I have to enable macros before I can see it. I have created the following statement in my application: ShellWait crPath+" /USER:" + userName + "/PASSWORD:" + simsPassword + " /REPORT:" + reportName + " /OUTPUT:" + importFolder + importFile, vbMinimizedFocus The application provides the parameters (importFolder + importFile are the destination path and filename). When run no error is reported, but the xls file is not created. Can anyone tell me where I am going wrong. A solution would benefit a number of different schools who use my application.