Working with Excel

[nageswaragunupudi]

I learn a lot by recording macros and looking at the code.

1. Start recording macro
2. Do the steps in Excel that you want to perform.
3. Stop recording
4. Look at the code to see what Excel did to accomplish the task

This is the best way.

[ukoenig]

I started with the Excel-Tool.

Macros are good, to find out a Syntax, but I don't want to start a macro every time
I'm looking for a Solution.

I still would like to have a Solution, the User can define a Macro, using a Multiline-get.
I don't know if it is possible, to run it after :
TOleAuto():New( "Excel.Application" )

What is included :
Editor for : oWin, oExcel, oWorkbook and oSheet.
Includes a Syntax-Field and a Memo-Field.

A Painter, to define Fonts, Colors and some more Settings.
Writing the Source, or start a Preview of a Excel-Sheet with the defined settings



Editor for oWin + Global-Informations, oExcel, oWorkbook and oSheet.



Best Regards
Uwe

[TimStone]

Your example screens look like the tool would be very helpful.

[SteveLai]

Is it possible to have more than one sheet in the workbook?

[Jeff Barnes]

You might also find this link useful ... it has a list of all the excel constants:

http://www.smarterdimensions.com/blog/?p=374


Another site I've used for help in the past:

http://www.excelforum.com/

or:

http://www.mrexcel.com/

[Jeff Barnes]

Yes you can have more than one sheet:

oExcel:Sheets(cSheet):Select()


Take a look here for a cheat sheet I made some time ago:

http://www.fivewin.info/html/tips___tricks_detail.php?id=46

[SteveLai]

Very helpful links with good examples Jeff ... many thanks!

I ended up using the following statements ...

oExcel:Worksheets(n):Activate() // where n = 1, 2, 3 ... etc
oSheet := oExcel:Get("ActiveSheet")

oSheet:name is useful for verifying which "n" is being used.