maybe i misunderstood what you want to do, you never said anything about allotted space before

in either case you can read the faq thread at the top of this forum for the tutorial on automating office applications