Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Cannot get handle on sheet in Excel
Topic Summary: Used to work, now doesn't
Created On: 24-May-2007 21:27
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Reik Schroeder, on Friday, May 25, 2007 1:33 PM

Answer:
Hi David,

did you tried to clear the args before putting the sheetnumber?
May be there is some old stuff in it?!

Greetings
Reik
 24-May-2007 21:27
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

I had written a batch script to automatically put the taught/not taught status of tasks in the Excel files our analyst guys work with. When I first wrote it, it worked like a champ with no issues.

Now however, it fails to get a handle on sheets in all files. Here is the code. I open excel, get the workbooks collection, open the file, get the sheets collection, and then try to get a sheet.

The files are still the same files as back then. As I said, the script used to work. I have no clue as to why it no longer does.

Edit: OleGet is returning "Problem with OLE Argument names."

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com

Edited: 24-May-2007 at 22:01 by David Pechacek
Report this to a Moderator Report this to a Moderator
 24-May-2007 22:16
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Answer Answer
Hi David,

did you tried to clear the args before putting the sheetnumber?
May be there is some old stuff in it?!

Greetings
Reik

-------------------------
Evosoft GmbH
for Siemens Industry Sector


Berlin, Germany
Report this to a Moderator Report this to a Moderator
 25-May-2007 13:33
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

..............Thanks Reik. Sometimes it takes someone else who hasn't been trying to figure it out all day to spot that. Much appreciated.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 2 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 2 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.