Adjust Microsoft Word table width via LotusScript

I've been struggling to solve this problem for days but still do not have a workaround. I need to adjust the Microsoft Word table width via LotusScript.

Here is the script:

 Set wrdApp = CreateObject
("Word.Application")
 wrdApp.documents.add
(xtempDrive$+"mydoc.doc") 
 
 wrdApp.Visible = True
 
 ' Add a new document
 
 Set wrddoc = 
wrdapp.Application.ActiveDocument
 
 Set wrdSelection = wrdApp.Selection
  Set range = wrdSelection.range
 Set tables = wrdApp.Selection.tables.add
(range, 1,7)
 
 Dim wdAdjustProportional As Integer
 Dim wdAdjustNone As Integer
 Dim wdAdjustFirstColumn As Integer
  
 wdAdjustProportional = 1
 wdAdjustNone = 0
 wdAdjustFirstColumn = 2
 
 wrdDoc.Tables(1).Columns(1).
SetWidth 1.18, wdAdjustProportional
 wrdDoc.Tables(1).Columns(2).
SetWidth 0.02, wdAdjustProportional
 wrdDoc.Tables(1).Columns(3).
SetWidth 2.5, wdAdjustProportional
 wrdDoc.Tables(1).Columns(4).
SetWidth  "0,02", wdAdjustProportional
 wrdDoc.Tables(1).Columns(5).
SetWidth "1,3", wdAdjustProportional
 wrdDoc.Tables(1).Columns(6).
SetWidth "0,02", wdAdjustProportional
 wrdDoc.Tables(1).Columns(7).
SetWidth "1,12", wdAdjustProportional
 wrdDoc.Tables(1).Rows.Alignment 1
' wrdDoc.Tables(1).Rows.SetLeftIndent -21.6

But LotusScript gives me this error, "Value out of range" when it hits the first "wrdDoc.Tables(x).Columns(x).SetWidth "xxxx", wdAdjustProportional."

Which is incorrect? Thank you very much.

I can't test this in my current situation. In the code I have seen, the table's variable isn't subscripted and the width is usually set with InchesToPoints. Try wrdDoc.Tables.Columns(x).Width = wrdDoc.InchesToPoints(xx). The figures in InchesToPoints are not quoted. Here is some sample code.

I would also check the Microsoft sites and forums.

Do you have comments on this Ask the Expert question and response? Let us know.

Dig Deeper on LotusScript

JSFTemplate Components Creating a component in JavaServer Faces is hard. The JavaServer Faces 2.0 EG recognizes the importance of making component authoring easier and has made it one of its top priorities. However, JSF 2.0 is too far off to wait for. Let's look at why it's hard to create a component, then I'll show one way to help simplify this process.

Creating a column color chart on a Web page using LotusScript Adding this LotusScript code to an agent will create a simple column chart on a Web page using divs. The script generates random colors and values, so you may need to provide your own values if you want further customization.

Coming to terms with call back Paul Touhy explains the concept of call back and gives you a practical example of using a call back along with a couple of procedures that might be of use when displaying lists of information on a Web page using CGIDEV2. Paul explains that call back is where a program issues a call to a procedure that, in turn, issues a call back to a procedure in the calling program. Your program issues a call to a standard procedure in a service program. But there is a little bit of logic that must be performed by this standard procedure that may be different on every call, depending on the caller. Click over to read the complete tip and get up to speed on using call back.

Count consecutive years I am struggling with writing a query to count consecutive years from the current year. I do not want to use a cursor. There is no requirement for the dates to be 365 days apart, just that they have different years. Any thoughts would be appreciated.

When to avoid using Enterprise Manager If you need to make a quick-and-dirty change to data in a relatively small table, SQL Server Enterprise Manager will get the job done. But if your column contains more than 1,024 characters -- take your editing needs elsewhere.

Database tip: All about subqueries A continuation of Mich's response to a user's question about different types of joins.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Domino experts

View all Domino questions and answers

Adjust Microsoft Word table width via LotusScript

Dig Deeper on LotusScript

Related Q&A from Brian Mahoney

Calculating results for a column in a Lotus Notes view

Do I use Formula or LotusScript to include a doclink to a Notes view?

'Customize this view' options are disabled in Lotus Notes databases

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Azure Bastion brings convenience, security to VM management

Microsoft closes IE zero-day on November Patch Tuesday

How to lock down rising Office 365 costs

Search400

iSeries tutorials

V6R1 upgrade planning checklist

Connecting multiple iSeries systems through DDM

SearchDataCenter

Microsoft quantum development turns toward hardware

Top 5 options for Linux certifications

New hardware, use cases shape server benchmarking needs

SearchContentManagement

Acquia cloud CMS on AWS, Vista cash flow raise user expectations

Adobe Sign introduces updates targeting mobile device users

Acquia, Drupal founder Dries Buytaert on open source, Vista, CDPs

Dig Deeper on LotusScript

Related Q&A from Brian Mahoney

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.