Excel Wscript Selection Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ralf Meuser - 23 May 2008 10:59 GMT

Hi there

I created a wscipt like this

...
Set objXL = WScript.CreateObject ("Excel.Application")
...
objWb7.Tab.ColorIndex = 7
Set objDanach =
objXL.ActiveWorkBook.WorkSheets(objXL.ActiveWorkBook.Worksheets.Count)
Set objWb8 = objXL.ActiveWorkBook.WorkSheets.Add(,objDanach)
objWb8.Name = "KPI4-7"
objWb8.Tab.ColorIndex = 8
...
objWb8.Cells(lig,1) = "HAPPY TEST"
objWb8.Columns("A:A").ColumnWidth = 3.9
objWb8.Range("A3:A12").Select
objWb8.Selection.Orientation = 90
objWb8.Selection.VerticalAlignment = xlCenter
objWb8.Selection.Interior.ColorIndex = 34

Every thing works fine. Only the 3 last Selection lines don't work.
What is wrong?

Thanks in davance for your help

Best regards

Ralf

Reply to this Message

stefan onken - 23 May 2008 14:28 GMT

hi Ralf,
Selection refers to the Application and not to a Worksheet, so try
objXl instead of objWb8
for the Selection.

Gruß
stefan

> Hi there
>
[quoted text clipped - 25 lines]
>
> Ralf

Reply to this Message

Ralf Meuser - 23 May 2008 16:01 GMT

Hi Stefan

Thanks a lot

Now it works
Have a nice Week end
bye

Ralf
hi Ralf,
Selection refers to the Application and not to a Worksheet, so try
objXl instead of objWb8
for the Selection.

Gruß
stefan

On 23 Mai, 11:59, "Ralf Meuser" <rmeu...@free.fr> wrote:

> Hi there
>
[quoted text clipped - 25 lines]
>
> Ralf

Reply to this Message