LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Strnage bug when pasting charts

Hi all,

I have encountered a stange bug. The bug occurs when copying an active
chartobject in Excel to PowerPoint.
(Excel is called from PowerPoint.)

The strange thing about this bug is that it occurs *only* on some pc:s not
on other.
The pc:s (stationary pc:s) have all Office 2003 sp3 MUI version and Windows
XP english all servicepacks installed.
I have tried to change the default printer with no result.

The code is as follows.

===========Code Start==============================

' Grab the existing instance of Excel
Set objExcel = GetObject(, "Excel.Application")

' If we have no Excel instance running warn the user and exit the
sub.
If objExcel Is Nothing Then
Call MsgBox(c_Message_ExcelNotStarted, vbExclamation, g_cAppTitle)
GoTo Routine_Exit
End If

' If no selected chart warn user and exit sub.
If objExcel.ActiveChart Is Nothing Then
Call MsgBox(c_Message_ExcelNoChart, vbExclamation, g_cAppTitle)
GoTo Routine_Exit
End If

===========Code End==============================

The error occurs in this part:

' If no selected chart warn user and exit sub.
If objExcel.ActiveChart Is Nothing Then
Call MsgBox(c_Message_ExcelNoChart, vbExclamation, g_cAppTitle)
GoTo Routine_Exit

End If

It fails on this line
objExcel.ActiveChart

and throws the error.

"Application or user-defined error"

Anybody has seen this before?

Thanks for help.

/Ulrik


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting charts to Word without Gridlines Brian Excel Worksheet Functions 5 August 10th 09 09:10 PM
pasting charts to new bookmarks in Word Kate Excel Programming 2 March 26th 07 07:59 PM
Pasting Charts from Excel to PowerPoint Willow[_5_] Excel Programming 0 April 14th 06 03:23 PM
Pasting worksheet with embedded charts FishMan Charts and Charting in Excel 2 October 5th 05 02:26 PM
Pasting excel sheets with charts Duane Charts and Charting in Excel 1 May 25th 05 09:07 PM


All times are GMT +1. The time now is 04:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"