Hi,
Quote:
Originally Posted by LimaCharlie
I can't consider that option of Edit|Links|Update coz there will be a weekly update on the source file. Thanks for the reply.
|
Why does that mean that Edit|Links|Update isn't an option?
I guess we could automate this from the Workbook_Open event handler (ie. a VBA solution), if it's worth the effort? I'm not aware of any reason why this wouldn't be viable - but then again, I've never tried it. I expect that if you download that add-in the code will not be protected, so it would give you a head start on the objects and methods you're going to be needing to work with.
Or someone else might have a better suggestion!
