Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: VBA results to Excel
Topic Summary:
Created On: 11-Apr-2007 20:04
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
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 SA Team, on Thursday, April 12, 2007 4:00 PM

Answer:

Hi

You need to add a reference to your project.
In VBA choose 'Tools' - 'References' and add :-
  Microsoft Excel x.x Object Library

You will then have acces to excel.application.

Alternatively use :-

Set appExcell = CreateObject("Excel.Application")

But you will not get auto complete with CreateObject as you are late binding.

Thanks
Ian

 11-Apr-2007 20:04
User is offline View Users Profile Print this message


robert mccauley

Posts: 22
Joined: 19-Jun-2006

I have compelted writing a vba script that picks out diagrams accroding to certain criteria. I know want to export the diagram names and last audit dates to an excel file but the SA VB doesnt support "excel.application" any suggestions???
Report this to a Moderator Report this to a Moderator
 12-Apr-2007 13:23
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Answer Answer

Hi

You need to add a reference to your project.
In VBA choose 'Tools' - 'References' and add :-
  Microsoft Excel x.x Object Library

You will then have acces to excel.application.

Alternatively use :-

Set appExcell = CreateObject("Excel.Application")

But you will not get auto complete with CreateObject as you are late binding.

Thanks
Ian



-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 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.