[Ms Excel 2013 Portablel
Saija Grzegorek
The code looks in the working directory of the word document, finds the first excel document (I only have 1 excel file per folder in my job, so this setup works for me), and changes the source of all OLE objects in the word document to match the excel document, which makes it possible to create a word/excel template pair and move them to different locations.
**NOTE: I also haven't really added any error checking as it's a quick and dirty macro that's used internally to facilitate portability AND I've never used vba before, so garbage cleanup etc. was a just kind of thrown in there, if there's a way to refactor everything and clean it up, please let me know.
It works for me by allowing me to copy paste either both a word and excel file together to a new location and run the macro, or by allowing me to copy paste the word document only and run the macro to link it to an excel doc in the new location.
**I should also note that I only needed to look in the body and header/footer stories for the links we use, so this code is not as robust as it could be, but I don' think it would be too tough to add another loop or two to cover off any missing stories
If you are still looking for a way to create portable links between Excel and Word, our Excel-to-Word Document Automation Add-in may help. Unlike native linking through Office you can: rename files, copy/paste and reorganize content, share the linked files, etc. The same Excel document can update multiple destination Word and/or PowerPoint report templates. You only need to set up the links once and they can be updated numerous times. I hope this helps, you can find out more at -Automation
Functional. Portable. Easy to use and adjust. Lightweight. Forward thinking and adaptable. These are all keywords Feedback Sports work stand users have used to describe the Colorado company's products. With the introduction of the Omnium Over-Drive Portable Trainer with Tote Bag, the same qualities that made event and race travel simpler with Feedback work stands comes to warm-up and prep. If you have every hauled your 35-50 lb fluid trainer from the parking lot to the warm-up zone, you know how little fun it can be before and after an event. The Omnium Over-Drive Portable Trainer weighs just 13.3 lbs, yet is highly adjustable, can be used for road, cross or mountain bikes, with any tire choice. Breathe, and let that all sink in for a minute.
The simple fork-mount design has been optimized for warm-up, but can also be used for general bike travel, and even as your winter trainer. The two 4 inch diameter double-wall aluminum drums carry a progressive magnetic resistance system that is amazingly quiet, and quite effective. As you work hard, the magnetic system, called Internal Progressive Resistance (IPR) adds resistance, in a similar way a fluid trainer does. The resistance is there, and the curve is designed to match road feel- no harsh acceleration or deceleration responses. The IPR itself is virtually silent, with any noise more likely coming from the tire-drum interface. And because your body weight and pedaling action keeps the tire in place, you can use a non-smooth tire without worrying about heavy wear or strange resistance. You can even feel comfortable using your race tires, because without the added force of the locked-in drum pressure, you won't generate more friction or heat than you would riding on the road or trail.
The fork mount itself is compatible with all current front axle systems, and is future-proof as well. This is carried by the Feedback-standard tripod design for excellent stability, simple height adjustment and ease of use. The drum section is attached via a sliding system, that locks into place with a quick turn of a knob. Because this track system is slightly raised from the base of the tripod and the drum unit, you don't need pristine, flat ground to set-up safely. The unit comes fully assembled, and folds down to 25.75 x 7.25 x 8 inches with its tote bag.
If you have dreamed of a fully functional, lightweight trainer for events and travel, that can actually provide the resistance you require, Feedback Sports has read your mind, and delivered, in the way that only this innovative company works. The aluminum construction, ease of use, portability and attention to detail is standard for Feedback. All of us, as cyclists benefit from this innovation. We believe the Omnium Over-Drive Portable Trainer with IPR-110 sets a new benchmark for portable trainers, and we suspect you will as well.
795a8134c1