I'm being asked about doing the following:
I have an Excel Workbook and a worksheet with normal Excel stuff. The user will print the worksheet. Management would like me to include logic so that when the print of the worksheet happens other documents print as well (automatically). These other documents are legal attachments, maybe images of critical parts, etc. Essentially management wants to automate the process so the user doesn't forget any of the pieces that are needed for the whole package.
So in a way this is more like a print control operation where the user signals "Time to print" and I take control in VBA and start to output worksheets and such.
I guess I could store these documents (word, pdf, image, etc) on various worksheets in the workbook but I was hoping to not have to do that because of the increased size and because it freezes them to the version that existed at the time. It would be nicer to get them off our SharePoint (WSS 2/3) site.
Sure would love to hear your thoughts if you have done anything similar. Thanks.
I have an Excel Workbook and a worksheet with normal Excel stuff. The user will print the worksheet. Management would like me to include logic so that when the print of the worksheet happens other documents print as well (automatically). These other documents are legal attachments, maybe images of critical parts, etc. Essentially management wants to automate the process so the user doesn't forget any of the pieces that are needed for the whole package.
So in a way this is more like a print control operation where the user signals "Time to print" and I take control in VBA and start to output worksheets and such.
I guess I could store these documents (word, pdf, image, etc) on various worksheets in the workbook but I was hoping to not have to do that because of the increased size and because it freezes them to the version that existed at the time. It would be nicer to get them off our SharePoint (WSS 2/3) site.
Sure would love to hear your thoughts if you have done anything similar. Thanks.
