![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Adding a new Sheet Name in Excel Topic Summary: Created On: 5-Apr-2004 17:19 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() Answer: Thanks Dennis, I tried it and it's exactly what I was looking for | |
![]() |
|
Hi:
I am iterating through a project and would like to export the module names in a folder to new worksheets in Excel. I am having trouble writing the OLE function calls to Excel to add new worksheet. Can anybody help? |
|
![]() |
|
![]() |
|
The attached code will create a new worksheet, select it, and give it the supplied name. The sheet will be added as the first one, with the others moving to the right.
You will need to ensure all of your variables have been defined prior to using this code. -Dennis |
|
![]() |
|
![]() |
|
Thanks Dennis, I'll try this. one more question, what is the vbaCheckRes function?
Is it a built in DOORS function or a user defined function to check if the OLE function call does not return null? --Janet |
|
![]() |
|
![]() |
|
The vbaCheckRes function I'm referring to was taken from the DOORS standard Word exporter and is used to check the status of any vba call, such as oleMethod, oleGet, or olePut. It is simply a function that accepts a string as input, and if the string is non-null, it will display an error dialog and handle the error.
You can also remove the call to vbaCheckRes(...) out of the sample code I provided earlier and the script will function just as well. Below is the standard function and one I modified to simply report the error. -Dennis Edited: 6-Apr-2004 at 13:35 by Dennis Lockshine |
|
![]() |
|
![]() |
|
Thanks Dennis, I tried it and it's exactly what I was looking for
|
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Adding a new Sheet Name in Excel
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.