Excel print object?
 

Paul wrote:
Robert Baer wrote:
GS wrote:
* Page breaks will not show in a chart because a chart is "in front"
or overlays cells.

PageBreaks don't show at all; - they reside in the cell where they
are inserted!

** Furthermore, a chart can take a rather large number of cells
(C6..Q38).

** Again, what code is needed to print a chart?

Again, you can't print a chart (or any other object) apart from its
position on the worksheet. *Excel only prints sheet contents in their
respective location on a sheet*
* Not true; easy and simple when done manually:
* 1) Select the chart
* 2) File-- Print
* Done.

https://docs.microsoft.com/en-us/off...mbedded-charts


** Paul
No charts found; cannot work as-is.
If i change the word chart to shape i can find 16 shapes, which is
correct; it is the 4th shape, but one the activate crashes.
Then there is the problem of assigning a name to the print file.
Noodling around on that site was worse than not trying.
Tying the baby bird Goo-Gull,got nowhere.

Once upon a time, in one version of Excel,this worked:
ActivePrinter:="Acrobat PDFWriter", PrintToFile:= True, PrintToFile:=
True, _
PrintOut Copies:= 1, Preview:= False, Collate:= False, _
PrToFilename:=pPath + vNam + ".PDF"

Excel barfs.
Also, i was able to derive the above sequentially, comma to comma or
entry to entry from a pulldown in Excel - i think in edit.

No more; NO help even for ActivePrinter, were i started (i think).

Thanks.

Excel print object?
 

Robert Baer wrote:
Paul wrote:
Robert Baer wrote:
GS wrote:
* Page breaks will not show in a chart because a chart is "in
front" or overlays cells.

PageBreaks don't show at all; - they reside in the cell where they
are inserted!

Furthermore, a chart can take a rather large number of cells
(C6..Q38).

Again, what code is needed to print a chart?

Again, you can't print a chart (or any other object) apart from its
position on the worksheet. *Excel only prints sheet contents in
their respective location on a sheet*
* Not true; easy and simple when done manually:
1) Select the chart
2) File-- Print
Done.

https://docs.microsoft.com/en-us/off...mbedded-charts


Paul
No charts found; cannot work as-is.
If i change the word chart to shape i can find 16 shapes, which is
correct; it is the 4th shape, but one the activate crashes.
Then there is the problem of assigning a name to the print file.
Noodling around on that site was worse than not trying.
Tying the baby bird Goo-Gull,got nowhere.

Once upon a time, in one version of Excel,this worked:
ActivePrinter:="Acrobat PDFWriter", PrintToFile:= True, PrintToFile:=
True, _
PrintOut Copies:= 1, Preview:= False, Collate:= False, _
PrToFilename:=pPath + vNam + ".PDF"

Excel barfs.
Also, i was able to derive the above sequentially, comma to comma or
entry to entry from a pulldown in Excel - i think in edit.

No more; NO help even for ActivePrinter, were i started (i think).

Thanks.

I tried to set myself up a trial version of Office 2003
to test, but that didn't work. Wouldn't activate.

What if you were to use the menus in Excel, to print the
entire document to PDF. So that you know all the
objects are in the document.

Then, use a PDF editor to re-arrange the content,
removing the parts you don't want.

You could try LibreOffice Draw as a PDF Editor of sorts.
Just print off one page as a test first, and experiment
with that.

Paul

Excel print object?
 

Paul wrote:
Robert Baer wrote:
Paul wrote:
Robert Baer wrote:
GS wrote:
* Page breaks will not show in a chart because a chart is "in
front" or overlays cells.

PageBreaks don't show at all; - they reside in the cell where they
are inserted!

** Furthermore, a chart can take a rather large number of cells
(C6..Q38).

** Again, what code is needed to print a chart?

Again, you can't print a chart (or any other object) apart from its
position on the worksheet. *Excel only prints sheet contents in
their respective location on a sheet*
* Not true; easy and simple when done manually:
* 1) Select the chart
* 2) File-- Print
* Done.

https://docs.microsoft.com/en-us/off...mbedded-charts


*** Paul
* No charts found; cannot work as-is.
* If i change the word chart to shape i can find 16 shapes, which is
correct; it is the 4th shape, but one the activate crashes.
* Then there is the problem of assigning a name to the print file.
* Noodling around on that site was worse than not trying.
* Tying the baby bird Goo-Gull,got nowhere.

* Once upon a time, in one version of Excel,this worked:
ActivePrinter:="Acrobat PDFWriter", PrintToFile:= True, PrintToFile:=
True, _
PrintOut Copies:= 1, Preview:= False, Collate:= False, _
PrToFilename:=pPath + vNam + ".PDF"

* Excel barfs.
* Also, i was able to derive the above sequentially, comma to comma or
entry to entry from a pulldown in Excel - i think in edit.

* No more; NO help even for ActivePrinter, were i started (i think).

* Thanks.

I tried to set myself up a trial version of Office 2003
to test, but that didn't work. Wouldn't activate.

What if you were to use the menus in Excel, to print the
entire document to PDF. So that you know all the
objects are in the document.

Then, use a PDF editor to re-arrange the content,
removing the parts you don't want.

You could try LibreOffice Draw as a PDF Editor of sorts.
Just print off one page as a test first, and experiment
with that.

** Paul

I certainly do not want to do manual fiddling for each desired result
200 times!
Do not like the idea even for one result.

So far, the best i have squeezed out is initially set Print Area
C12..Q66, use my program to calculate and place shapes in iobj.3, STOP
program, manually file/print/name, then continue so program can then
"erase" the work to restore original inserted picture.

Good for onseies but far from ideal.
Would be VERY nice to have Excel do that manual part.....

Thanks.

Reshaping Printing objects
 

Excel has many Shapes to choose from, but sometimes the Shape you need is not in the gallery. In such a case, you may be able to modify one of the existing shapes using one of these techniques:

Rotate the Shape:
When you select a Shape, it displays a small green dot. Click and drag this dot to rotate the Shape.

Group multiple Shapes:
You may be able to create the Shape you need by combining two or more Shapes and then grouping them.

Reconfigure the Shape:
Many of the Shapes display one or more small yellow diamonds when the Shape is selected. You can click and drag this diamond to change the Shape's outline. The exact behavior varies with the AutoShape, so you should experiment and see what happens.

Create a Freeform Shape:
Select the Freeform Shape (in the Lines category of the Shapes gallery) to create a custom Shape.

Convert an existing Shape to a Freeform Shape:
If an existing Shape is close to what you want, convert it to a Freeform Shape and then edit its points. Select the Shape and choose Drawing Tools Format Insert Shapes Edit Shape Convert To Freeform. Then, with the shape still selected, choose Drawing Tools Format Insert Shapes Edit Shape Edit Points. You can then drag the points to reconfigure the Shape.

Regards,
Jerry