Kinook Software Forum

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

Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
  #1  
Old 07-02-2004, 07:24 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,003
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 http://support.microsoft.com/default.aspx?kbid=260410).

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, 2582 views)
Reply With Quote
Reply

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 03:06 PM.


Copyright © 1999-2023 Kinook Software, Inc.