Can't agree more.. just read the docs... I can do just about anything I want to in Excel with OLE now that I gave them a good read. Honestly the Microsoft doc for Excel is good (once you understand their style). True its all VBA code, but its the same object model (duh!) so it should make sense if you read it like pseudo-code

Good luck with your problem. It is an easy one to fix and will be much more rewarding when you figure it out yourself. It will get you familiarized with the object browser in Excel also. This is a good and simple start for learning how to do more than simply place values in a cell

If you have more questions once you have read the docs or don't understand something.. please update us...

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.