Re^3: merging cells in excel


Think about Loose Coupling
	PerlMonks

Re^3: merging cells in excel

by bmann (Priest)

on Apr 22, 2005 at 05:05 UTC ( [id://450270]=note: print w/replies, xml )

Need Help??

in reply to Re^2: merging cells in excel
in thread merging cells in excel

You won't find it in the Win32::OLE docs. I first learned it a long time ago writing Excel macros with VBA. The Excel help files and the object browser are your friends.

If you are using Excel automation regularly, you'll want to be familiar with Excel's object model. You can find help and diagrams in the help files, but the Programming help files are not installed by default.

Once you are familiar with the object model, use the Object Browser for quick lookups. If you don't already know where to find the object browser, open the VBA code window (I use Alt+F11) and then open the Object Browser using the View menu or just hit F2.

Another great place to learn is cacharbe's Using Win32::OLE and Excel - Tips and Tricks.

Good luck!

Update: And remember the macro recorder to help with syntax.