[Ri...] Posted June 13, 2019 Share Posted June 13, 2019 Is there a way to not make the Excel report open after the end of each program? Link to comment Share on other sites More sharing options...
[Ow...] Posted June 13, 2019 Share Posted June 13, 2019 I have no answer but, good question. Link to comment Share on other sites More sharing options...
[De...] Posted June 13, 2019 Share Posted June 13, 2019 I believe it must open to load the data into the report template. In a past life, we places a macro in the primary template to close excel after it saved the file. There was still lag time due to opening excel, populating the sheet, saving and closing, but the work was in the background. This saved the operator the extra step of closing the excel sheet. Link to comment Share on other sites More sharing options...
[Br...] Posted June 13, 2019 Share Posted June 13, 2019 Looking at the VBA code, it has to open to trigger the macro that populates the spreadsheet. I can't for the life of me figure out where it saves it though. I watched it step by step and the saved report pops up in the the file as soon as the main macro hits the "end sub" line. I tried sticking "application.end" just prior to the end sub, but it doesn't save it then. Maybe someone with some better VBA skills can figure this out. I guess I would just put in a command to save it where I want it and close the application. But if you ever want to change the path, you'll have to edit the code. Link to comment Share on other sites More sharing options...
[ro...] Posted June 20, 2019 Share Posted June 20, 2019 is your TABLE FILE selected for on and have you checked the EXCEL block on the run page? Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in