Passing parameters to VB

[Tim Roberts]

"koia" <ingmar.ko.andersson at glocalnet.net> wrote:

>Hi,
>
>I am using win32com for the Python interface to my Excel shreadsheets.
>
>When I turn on Macro recordiong in Excel while filling a rectangle with
>text information, a part of the VB code produced is the following:
>
>    With Selection.Characters(Start:=1, Length:=11).Font
>        .Name = "Arial"
>        .FontStyle = "Normal"
>        .Size = 10
>        .Strikethrough = False
>        .Superscript = False
>        .Subscript = False
>        .OutlineFont = False
>        .Shadow = False
>        .Underline = xlUnderlineStyleNone
>        .ColorIndex = xlAutomatic
>
>What is the syntax for passing the parameters Start:=1, Length:=11 to
>VB from a Python function, if I want to control these properties of the
>text in the Excel spreadsheet?

If you check the object model documentation, you'll find that "Start" and
"Length" are the only two parameters to Characters, so Characters(1,11)
should work.

However, in a few minutes of experimentation, I was unable to get
Characters to accept any parameters from Python.  I can set the whole cell
to bold by this:

  xl = win32com.client.Dispatch("Excel.Application")
  wb = xl.ActiveWorkbook
  ws = wb.Worksheets(1)
  r = ws.Range("A1")
  r.Characters.Font.Bold = True
-- 
- Tim Roberts, timr at probo.com
  Providenza & Boekelheide, Inc.