kemperohlmeyer
Board Regular
- Joined
- Oct 4, 2006
- Messages
- 73
Do anyone have some code that will automatically print and close a spreadsheet when it is opened?
background: we are performing a data integration on our database. Part of our program is able to open external documents and programs. We want to have our prog point to an excel file, open it (that's the part we can do) and then, once opened (and without external prompting), prints and closes the spreadsheet.
Any code would be great--especially regarding how the macro could automatically run. Thanks.
ko
background: we are performing a data integration on our database. Part of our program is able to open external documents and programs. We want to have our prog point to an excel file, open it (that's the part we can do) and then, once opened (and without external prompting), prints and closes the spreadsheet.
Any code would be great--especially regarding how the macro could automatically run. Thanks.
ko