Kinook Software Forum

Go Back   Kinook Software Forum > Visual Build Professional > [VBP] Frequently Asked Questions > Scripting

Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
Old 07-02-2004, 08:24 AM
kinook kinook is online now
Join Date: 03-06-2001
Location: Colorado
Posts: 6,001
How can I modify an Excel worksheet or Office document from a build?

Attached is a sample (taken from the 'Editing a Workbook' sample in

Some things to be aware of when working with those samples:

1) Remove the ' As <Excel.Application>' from variable declarations (everything is a variant in VBScript).
2) VBScript doesn't support named parameters (i.e. xlApp.Workbooks.Open FileName:="c:\My Documents\Book1.xls"); pass all required parameters in the order required without naming.
3) Use the actual numeric value of constants defined in the Excel object model, since these constants aren't available from script.

See the Microsoft Excel Visual Basic Reference in the Excel help for details on 2 and 3.
Attached Files
File Type: bld excel.bld (1.3 KB, 2551 views)
Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

All times are GMT -5. The time now is 08:11 AM.

Copyright 1999-2023 Kinook Software, Inc.