Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 212
Default Points measurement problem

Hello every one,

Facing some funny problem with excel.
I was adding some pictures in a sheet, which has ever
worked without problem.
But this time, I was stumped.
Excel suddenly started adding the pictures in wrong position
and wrong size.
After 2 hrs of head scratching I found this.
If you access HPageBreaks or VPageBreaks Property
and then add the picture, the Points scale gets multiplied by
6.2571 !
Please see code below:
I am using HPageBreaks.Count quite earlier in my code,
then last adding some pictures. In Below code I added
line x = .HPageBreaks.Count just to show my point.
When this line is commented off, the pictures get added
at correct position. If comment removed, the pictures
get added with specidied position * 6.2571, size * 6.2571
(ineasted of size 70,70 , it adds size (438,438)

Sub Dec22Presentation()
With ThisWorkbook.Worksheets("Sheet1")
'x = .HPageBreaks.Count
For i = 1 To 5
.Shapes.AddPicture "c:\tph5000.jpg", _
msoFalse, msoTrue, i * 200, 100, 70, 70
Next
End With
End Sub

Any idea how to reset back the points scale?

Sharad


Reply
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
How to Format numbers from percentage points to basis points Robaroo Excel Discussion (Misc queries) 2 April 3rd 23 06:58 PM
change column measurement to points from inches LMS Setting up and Configuration of Excel 0 May 5th 09 07:24 PM
Problem charting two points of data Patrick C. Simonds Charts and Charting in Excel 1 January 28th 09 07:59 AM
How to set measurement clara Excel Discussion (Misc queries) 0 April 25th 07 03:54 PM
Excel 2003 xy chart - problem plotting more than 330 points ehmcneill Charts and Charting in Excel 1 December 17th 05 12:18 AM


All times are GMT +1. The time now is 12:10 AM.

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

About Us

"It's about Microsoft Excel"