Camera Tool
 

Hello All,

I Have a problem of using Excel Camera command in my macro. Here is my codes:

ActiveSheet.Range("A4:H15").Select
Selection.Copy
ActiveSheet.Pictures.Add(201.75, 192.75, 375, 328.5).Select
Selection.Height = 294
Selection.Width = 410.25

It works well in most of my computer. However, I have a problem in one
computer. The content of the range A4:H15 that I size it to fit with the
width 410.25 and the height = 294 is larger than the normale and it also move
a little to the left. I think the problem is from the printer configuration
but I do not know which part. Any clue will be very appreciated.

Christine

Camera Tool
 

If I follow you correctly I think you should do something like this:

Selection.Height = Range("A4:H15").Height
Selection.Width = Range("A4:H15").Width

--
Jim
"Christina" wrote in message
...
| Hello All,
|
| I Have a problem of using Excel Camera command in my macro. Here is my
codes:
|
| ActiveSheet.Range("A4:H15").Select
| Selection.Copy
| ActiveSheet.Pictures.Add(201.75, 192.75, 375, 328.5).Select
| Selection.Height = 294
| Selection.Width = 410.25
|
| It works well in most of my computer. However, I have a problem in one
| computer. The content of the range A4:H15 that I size it to fit with the
| width 410.25 and the height = 294 is larger than the normale and it also
move
| a little to the left. I think the problem is from the printer
configuration
| but I do not know which part. Any clue will be very appreciated.
|
| Christine

Camera Tool
 

Hi Jim,

Hi Jim,
The problem is not the syntax error but it is is possible from the setting
of the printer on each computer. On the computer that I have problem the
picture selected from the Camera is no more proportion with the page. It is
bigger and not at the right position. However, on all of my others computers,
the picture is at the right position.
Christine

"Jim Rech" wrote:

If I follow you correctly I think you should do something like this:

Selection.Height = Range("A4:H15").Height
Selection.Width = Range("A4:H15").Width

--
Jim
"Christina" wrote in message
...
| Hello All,
|
| I Have a problem of using Excel Camera command in my macro. Here is my
codes:
|
| ActiveSheet.Range("A4:H15").Select
| Selection.Copy
| ActiveSheet.Pictures.Add(201.75, 192.75, 375, 328.5).Select
| Selection.Height = 294
| Selection.Width = 410.25
|
| It works well in most of my computer. However, I have a problem in one
| computer. The content of the range A4:H15 that I size it to fit with the
| width 410.25 and the height = 294 is larger than the normale and it also
move
| a little to the left. I think the problem is from the printer
configuration
| but I do not know which part. Any clue will be very appreciated.
|
| Christine

Camera Tool
 

Sorry my point wasn't clear. I don't recall saying anything about a syntax
error. Your problem is that you are hard wiring coordinates on the
assumption that they hold across machines. You have to determine them
dynamically. My code (I cannot tell if you tried it) dynamically determines
the size (as best I can tell what you're doing) but not the location.
Something like this: 201.75, 192.75, 375, 328.5 is a nonstarter. Use
Range("B10").Left, Range("B10").Top, etc.

--
Jim
"Christina" wrote in message
...
| Hi Jim,
|
| Hi Jim,
| The problem is not the syntax error but it is is possible from the setting
| of the printer on each computer. On the computer that I have problem the
| picture selected from the Camera is no more proportion with the page. It
is
| bigger and not at the right position. However, on all of my others
computers,
| the picture is at the right position.
| Christine
|
| "Jim Rech" wrote:
|
| If I follow you correctly I think you should do something like this:
|
| Selection.Height = Range("A4:H15").Height
| Selection.Width = Range("A4:H15").Width
|
| --
| Jim
| "Christina" wrote in message
| ...
| | Hello All,
| |
| | I Have a problem of using Excel Camera command in my macro. Here is my
| codes:
| |
| | ActiveSheet.Range("A4:H15").Select
| | Selection.Copy
| | ActiveSheet.Pictures.Add(201.75, 192.75, 375, 328.5).Select
| | Selection.Height = 294
| | Selection.Width = 410.25
| |
| | It works well in most of my computer. However, I have a problem in one
| | computer. The content of the range A4:H15 that I size it to fit with
the
| | width 410.25 and the height = 294 is larger than the normale and it
also
| move
| | a little to the left. I think the problem is from the printer
| configuration
| | but I do not know which part. Any clue will be very appreciated.
| |
| | Christine
|
|
|