Nologik
07-18-2008, 11:46 AM
Hey guys I have 2 questions both regarding shared workbooks:
I developed an excel workbook that does a lot of work for the end user, none of which is saved into the workbook itself but onto other workbooks. I kept releasing new versions as new reports needed to be run but it is getting tiring. I was wondering if I could share the workbook and load it on the network drive and create shortcuts on the end users' desktop so that anytime I change or update the workbook, the end user automatically goes into it? Any drawbacks or problems with this method?
2nd question:
When the workbook is shared the [Shared] appears in the workbook title bar so how would appactivate to activate itself work when it's done working with the other workbooks. Appactivate seems to fail with shared workbooks. Any better ways guys?
THanks!
I developed an excel workbook that does a lot of work for the end user, none of which is saved into the workbook itself but onto other workbooks. I kept releasing new versions as new reports needed to be run but it is getting tiring. I was wondering if I could share the workbook and load it on the network drive and create shortcuts on the end users' desktop so that anytime I change or update the workbook, the end user automatically goes into it? Any drawbacks or problems with this method?
2nd question:
When the workbook is shared the [Shared] appears in the workbook title bar so how would appactivate to activate itself work when it's done working with the other workbooks. Appactivate seems to fail with shared workbooks. Any better ways guys?
THanks!