My final year project, is to create a "Project Mgmt Review" automation tool. Every month, the company I am working for asseses it's monthly performance's in the form of 14 spread sheets which it in turn incorporates into a 20 slide powerpoint. So at the end of every month, the values in the excel spreadsheet changes,which in turn has to be incorporated into the powerpoint PMR. Until I create, this software, At the end of every month , someone will have to manually cut,copy , paste and replace the old excel sheets in the PMR, with the new one. My project is to automate this entire process, with the click of a button.
I would have to generate a mechanism,whereby I can access the Excel spreadsheets using vb, an incorporate them into powerpoint.
I have been using macro's succesfully , in all my test sheets. But, there is a small problem, when I update the sheet and call the macro again, The size of the worksheet either shrinks dramatically, or it suddenly become's enlargened.Does anyone know why?
Another query of mine, is that I am not very certain as to how, the end user i.e the company I am doing my project with, will utilize this software. Do they have to go to a powerpoint file, with macro's enabled and then run the macro, Or Is their any mechanism whereby, I can create a separate form whereby they can use this tool like a normal Visual basic software. Please reply at the earliest.
Thank you.